SQL - Death By Patterns

Browse by Tags

All Tags » SQL (RSS)
Friday, July 20, 2007 7:26 AM

Managing your SQL Log files - Part 2

<PreAmble type="rantish-apology">Well it seems my home internet just isn't playing along. I wrote this (and the previous) post in Windows Live Writer but every time I wanted to publish, my internet at home stopped working. To make matters worse, Windows Live Writer doesn't work behind my company firewall. So anyway, I copied and pasted this and the previous post out of Live Writer, but the formatting gets kinda wonky. Sorry about that, hope the content makes up for it.<...
Posted by CalmYourself | 1 comment(s)
Filed under: , , ,
Wednesday, July 11, 2007 7:19 AM

Managing your SQL Log files

Part 2, covering how the transaction log is affected by the recovery model and how it affects data loss, is now out OK, everyone who has put some thought into the setup of their transaction log file, please raise your hand... ...I thought so. The sad truth is that there are very few people who think through the log files for their production systems - often with dramatic results. Each and every single SQL Server database has both a data file and a log file, both of which serve an important function...
Posted by CalmYourself | 9 comment(s)
Filed under: , , , ,
Thursday, May 03, 2007 1:36 PM

What exactly is 4th (fourth) normal form?

Haven’t posted in a while, sorry about that. My planned series on data-mining seems to have lost some steam, but I will try and get back to it sometime in the future, rest assured. There was a SQL Question of the Day asked on this topic over at SADeveloper.net What is database normalization? Database normalization is a design techniques aimed at reducing redundancy and inconsistency of data. There are various stages of normalization, starting with first normal form and proceeding through to sixth...
Posted by CalmYourself | 5 comment(s)
Filed under: ,
Friday, April 13, 2007 5:44 AM

SQL Rand() trap - Same value per row?

While preparing the next article in my data mining series I needed to use the RAND () function in SQL but got quickly reminded that not everyone will know that RAND() will only generate one random number per query. To illustrate: The Problem: Execute the following SQL: SELECT RAND () Gives you a nice random number between 1 and 0. Perfect. Now, run the query multiple times. A different random number each time, great. Now, create a temporary table, populate it with some data and run the SELECT from...
Posted by CalmYourself | 6 comment(s)
Filed under: , ,
Wednesday, April 11, 2007 7:08 AM

SQL Server 2005 Data Mining Series - Part 1 - Versions

This is the first part of a multi-part series covering data mining in SQL Server 2005. This edition covers the absolute basics of what you will need, i.e. making sure you have the right version of SQL to do what you want. There are numerous versions on SQL Server 2005 available, each of which has certain features, limitations and costs. Each edition may have certain OS limitations which need to be taken into account too. For the purpose of this entry, however, I will be focusing only on which features...
Posted by CalmYourself | with no comments
Filed under: , ,