What is the use of DBCC commands?

What is the use of DBCC commands?

DBCC is database consistency checker. DBCC commands are used to check the consistency of the databases.
DBCC CHECKDB - Ensures that tables and the indexes are correctly linked in the database.
DBCC CHECKALLOC - Ensures all pages are correctly allocated in the database.
DBCC SQLPERF - Provides report on current usage of transaction log in percentage.
DBCC CHECKFILEGROUP - Checks all tables file group for any damage
Define COLLATION
Collation is the order that SQL Server uses for sorting or comparing textual data........
Where is users names and passwords stored in SQL Server?
They are stored in master db in the sysxlogins table.......
What is BCP?
It is utility used to copy huge data from tables and views without copy schema of the server object........
Post your comment