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: Agile
Post
My links of the week – February 2, 2014
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...