patternsqlMinor
Is there a complete list of Online operations for each SQL Server version?
Viewed 0 times
operationseachsqlversiononlinecompleteforserverlistthere
Problem
As we are about to change some of the large tables in our 5TB database I found myself needing a list of the operations that can be performed online and the which require full locks to be held while they run. Ideally, this list would also contain information about which statements require the SCH-M lock to commit at the end.
While I know most of them from my time in Microsoft, I was surprised that I could not find a publicly available list of online operations as they evolved from SQL Server 2005 and all the way to 2014 CTP.
Does anyone have such a list available? If not, I may decide to create it.
While I know most of them from my time in Microsoft, I was surprised that I could not find a publicly available list of online operations as they evolved from SQL Server 2005 and all the way to 2014 CTP.
Does anyone have such a list available? If not, I may decide to create it.
Solution
Sounds like an undertaking. Online index operations are not available in every edition of Microsoft SQL Server, hopefully this can get you started (it's in table form):
SQL Server 2012:
http://msdn.microsoft.com/en-us/library/ms190981.aspx
SQL Server 2008R2: http://msdn.microsoft.com/en-us/library/ms190981(v=sql.105).aspx
SQL Server 2008: http://msdn.microsoft.com/en-us/library/ms190981(v=sql.100).aspx
SQL Server 2005: http://msdn.microsoft.com/en-us/library/ms190981(v=sql.90).aspx
SQL Server 2012:
http://msdn.microsoft.com/en-us/library/ms190981.aspx
SQL Server 2008R2: http://msdn.microsoft.com/en-us/library/ms190981(v=sql.105).aspx
SQL Server 2008: http://msdn.microsoft.com/en-us/library/ms190981(v=sql.100).aspx
SQL Server 2005: http://msdn.microsoft.com/en-us/library/ms190981(v=sql.90).aspx
Context
StackExchange Database Administrators Q#56182, answer score: 5
Revisions (0)
No revisions yet.