A Seek Isn’t Always Good Enough
Index seeks are good, right? Normally they are, unless the index that you are seeking against isn’t the correct index. If we look at Figure 1 everything in this plan looks good, right? The cost of the index seek against Table1.Index4 is 0%, the IO cost is very low as is the CPU cost. So […]
Recommended reading from mrdenny for October 24, 2014
This week I’ve found some great things for you to read. These are a few of my favorites that I’ve found this week. Should new index columns be in the key, or included? IT books that should be on your shelf Database Mail … and then the SMTP Server changed Session State Provider for SQL […]
And your SQL PASS Speaker Idol Judges Are…
If you are attending the SQL PASS Summit in Seattle, WA in November 2014 you’ve probably heard that the SQL PASS Summit is going to be having it’s first speaker idol with the winner of the competition winning a speaking slot at the SQL PASS Summit in 2015. In order to have a contest we […]
Recommended reading from mrdenny for October 17, 2014
This week I’ve found some great things for you to read. These are a few of my favorites that I’ve found this week. The Five Alarm Meeting How to use Git on Windows Server 2012 CodeSOD: State of the UNION You Need a DBA Austrian Tor Exit Node Operator Found Guilty As an Accomplice This […]