Recommended reading from mrdenny for November 07, 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. MacGyver Moments Ask Slashdot: Is Running Mission-Critical Servers Without a Firewall Common? The 2008 R2 Bug Fix That Breaks RCSI A Partitioned Table May Limit the Runtime MAX DOP of Create/Alter Index […]
SQL Karaoke Is TONIGHT! – Or it would have been, if this post went out on time.
I just want to remind everyone that SQL Karaoke is Tonight at Cow Girls, Inc. Be sure to get signed up and show up for a great time with an awesome Rockaraoke Band. A great time will be had by all. I can’t wait to see you there. Denny
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 […]