Here are the links for the past week. SQL Server: Kendra Little’s SQL Server DMVs that Lie addresses some misleading or not completely accurate information provided by some of the SQL Server Dynamic Management Views. Ami Levin’s SQL Server Optimizer – Under the Hood Part 1 is a part of a series on the SQL Server Optimizer....
Category: Links of the week
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...