Recommended reading from mrdenny for October 31, 2014

Happy Halloween! 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 Guard Changes on the Iron Throne For Half, Degrees In Computing, Math, Or Stats Lead To Other Jobs IT books that should be on your shelf Slow query using […]

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 […]