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...
Tag: Azure
Post
My links of the week – January 12, 2014
Here are my choice of links for the past week. SQL Server: Brent Ozar’s What’s the Smallest SQL Server You Should Build? provides some advice on the hardware configuration for a “small” SQL Server that gets the best value from the licensing costs of SQL Server 2012, considering both the Standard and Enterprise Editions and...