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...
Category: Links of the week
Post
My links of the week – February 9, 2014
Here is my choice of links for the past week. SQL Server: Paul Randal’s Avoiding Knee-Jerk Performance Troubleshooting warns against superficial analysis of performance problems and offers examples of situations where that can happen, related to wait statistics. Kendra Little’s Statistics Matter on Temp Tables, Too shows that statistics are relevant in temp tables too and suggests...