New SQL 2008 R2 SP1 trace flag adjusts autostats threshold
I recently learned about a new trace flag which has been introduced in SQL Server 2008 R2 SP1 (and SQL Server “Denali”). This trace flag, number 2371, changes the way that the SQL Server figures out when auto-stats should kick in. Up until now auto-stats was fixed to kick in every time that the column […]
Let have lunch and talk storage
This year at the SQL PASS summit I’m once again taking a lunch table for the Birds of a Feather lunch on Friday. And even better than last year I don’t have a session that I’m presenting right before lunch so I’ll actually be there on time (last year I was like 30 minutes late […]