Here is my choice links for the past week. SQL Server: Kendra Little’s UPDATE STATISTICS: the Secret IO Explosion shows how updating statistics can cause a bit of IO and suggests ways to accomplish it in a lighter fashion. Gregory Larsen’s Stairway to Advanced T-SQL Level 2: Writing Subqueries is a rather comprehensive presentation of subqueries in T-SQL. Aaron...
Tag: WASD
Post
My links of the week – 29 December, 2013
Here are the links for this week. SQL Server: Kendra Little’s Can High MaxDOP make a query SLOWER? explores the relation between the MAXDOP value and query performance. Having a high value doesn’t necessarily mean better performance. In fact, it can mean worse performance. Daniel Farina’s Understanding SQL Server Memory-Optimized Tables Hash Indexes provides a detailed explanation of...