[Video] Office Hours: SQL Server 2008 R2 Edition, I Guess


I went through your highest-voted questions from Pollgab and talked through ’em, and strangely, there was a bit of a 2008R2 theme!

Here’s what we covered:

00:00 Introductions 02:00 Pete Donnelly: Hi Brent, I have a 7 TB DB and the largest table is 2 TB, has 6 indexes and 6 related Statistics. It has 42 “_WA_Sys” Statistics. We truncate this table every Jan 1st, to start the new year with a empty table. Should I drop the “_WA_Sys” Statistics when I truncate this table? 03:58 LifelessDBA: Hi Brent, Suppose SQL 2022 GA is available now, Is there any