Database Console Commands (Transact-SQL)

Database Console Commands (Transact-SQL)

Edited by 

List price: US$38.00

Currently unavailable

Add to wishlist

AbeBooks may have this title (opens in new window).

Try AbeBooks

Description

Please note that the content of this book primarily consists of articles available from Wikipedia or other free sources online. The Database Console Commands are a series of statements in Transact-SQL programming language to check the physical and logical consistency of a Microsoft SQL Server database. These commands are also used to fix existing issues. They are also used for administration and file management. DBCC was previously expanded as Database Consistency Checker. This statement is used to recreate the indexes for a particular table. This statement rebuilds indexes in a single step. It also assigns fresh pages to reduce internal and external fragmentation.This statement is used to drop or delete a damaged database. However, this command is no longer available with Microsoft SQL Server 2005 and later versions of Microsoft SQL Server.show more

Product details

  • Paperback | 68 pages
  • 152 x 229 x 4mm | 113g
  • Miss Press
  • United States
  • English
  • 6136581167
  • 9786136581163