Connect digest : 2009-12-31

Like Hugo's immensely popular item pushing for SQL Server 2005 Service Pack 3, Steve Jones has created suggestions prompting new service packs for both 2005 and 2008:

#522122 : Service Pack 4 for SQL Server 2005

#522123 : SQL Server 2008 Service Pack 2

In a predictability area, I suggested that online index rebuilds should populate percent_complete in sys.dm_exec_requests (just like index reorganization does today):

#520072 : Online index operations should populate percent_complete in sys.dm_exec_requests

And on the consistency front, I've also asked for them to expand several DDL keywords to accept both NOWAIT and NO_WAIT, instead of one or the other: 

#520245 : DDL : support both NO_WAIT and NOWAIT

Aaron Bertrand

I am a passionate technologist with industry experience dating back to Classic ASP and SQL Server 6.5. I am a long-time Microsoft MVP, speak frequently at conferences, and write at SQLPerformance and MSSQLTips. In real life I am a father of two, an architect at Wayfair, and my pronouns are he/him.