L.A. SQL Server Professionals Group

Welcome to the Los Angeles SQL Server Professionals Group

Next Meeting

Thursday,

March

20

DBCC Commands in SQL Server 2005 and SQL Server 2008

  • In-Person @ 110 Westwood Plaza Los Angeles, California, United States (map)
  • 18:30 - 21:30 Pacific Daylight Time
  • Language: English

Speaker: Dave Owen

Dave has, among other credits, a Microsoft Certified Trainer credential. In reviewing the Microsoft Official Curriculum for course 2789A, Administering and Automating Microsoft SQL Server 2005 Databases and Servers, he came across this passage:

Important DBCC commands are familiar to most DBAs but you should check the topics ?DBCC (Transact-SQL)? and ?Check Database Integrity Task? for the SQL Server 2005 thinking on these tools. The emphasis is changing to a heavier reliance on the automatic tasks. Also notice in topics such as ?DBCC INDEXDEFRAG (Transact-SQL)? that a number of DBCC commands will be removed in future versions of SQL Server. Ensure that your automation does not rely on commands or features that will eventually disappear from the product.

This caused him to ask: what is the role of DBCC commands both in SQL Server 2005 and SQL Server 2008? He will share the results of this answer with us during the March meeting.

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids