Chris's SQL Blog
Archives: March 2011
Why I don’t like NULLs and Nullable Columns
As I imagine (or hope), the majority of us adhere to some form of standards in the environment that they work in. Whether that be whether you have to wear a Shirt and Tie, be in for 9am or those of us in a Database or Development environment, Coding Standards. Read more
2 comments, 140 reads
Posted in Chris's SQL Blog on 25 March 2011
Database Mail – Collection of SQL Server Scripts
As part of my blogging I’ll be periodically providing readers with a collection of my scripts which I use on a daily basis (collected over the years) and hopefully others can gain from these and utilise them going forward.
Today i’m providing a list of Database Mail scripts I use… Read more
0 comments, 219 reads
Posted in Chris's SQL Blog on 21 March 2011
Poll: – Index Rebuild / Defrag, what page count filter do you set?
After reviewing a number of clients overnight index defrag / rebuild scripts over the years, I’m intrigued to know how many of us actually set the page count filter when capturing the fragmentation levels.
I know there’s a lot of debate around the value to set and personally I set… Read more
0 comments, 189 reads
Posted in Chris's SQL Blog on 11 March 2011



Subscribe to this blog