Fill Factor With Large Row Sizes
Produced: 26/10/2014 08:47:00
This is just a little something to look out for when administrating a database as I’ve seen it catch a few people out.

Basically it’s all about making sure you have the correct fill factor for your indexes so that you don’t unnecessarily bloat your databases as a whole.

Continued...
Check Your Database Growth Settings
Produced: 19/10/2014 08:43:00
This is another bug-bear of mine… it’s something I believe should always be set at the time of creating a database and then periodically checked and altered where necessary... and this applies not only to the data file but to the log file as well.

Continued...
Full Backup Does Not Truncate Log
Produced: 12/10/2014 08:30:00
This is a massive misconception that has been going around for a long while and it needs to be wiped out.

Basically this is the belief that if you have a database in FULL recovery mode and take a full backup, then it truncates the log.

This is NOT true.

Continued...
Basic Warning About UNION
Produced: 05/10/2014 10:28:00
I was looking for some sample code to help me with a personal C# application I was coding and in looking around I saw a perfect example as to what not to do when manipulating a database.

To be honest the C# code itself was pretty ropey, but aside from that I could see what the guy was trying to achieve but the t-SQL he was using would likely let him down at some point due to his misuse of “UNION”.

Continued...