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:
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: