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...
Category: Web Development
Post
My links of the week – December 15, 2013
Here is my selection of the links from the past week. SQL Server: Last week was T-SQL Tuesday week, Waits being this month’s subject. Robert L. Davis was the host, and several interesting posts are included in his roundup: T-SQL Tuesday #49: Wait For It Roundup. Basit Farooq’s Understanding SQL Server Query Optimization – Part...