Here is my choice of links for the past week. SQL Server: Jez Schultz Borland’s SQL Server Indexed Views: The Basics is a rather comprehensive post, as is usual the case with Simple Talk posts, explaining what indexed views are, the benefits that can result from its use, some requirements to ensure SQL Server actually uses...
Tag: SQL Server 2014
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...