Can you give me some DBCC command options?(Database
consistency check) - DBCC CHECKDB - Ensures that tables in
the db and the indexes are correctly linked.and DBCC
CHECKALLOC - To check that all pages in a db are correctly
allocated. DBCC SQLPERF - It gives report on current usage
of transaction log in percentage. DBCC CHECKFILEGROUP -
Checks all tables file group for any damage.
No Answer is Posted For this Question
Be the First to Post Answer
Difference b/w Clustered & non-clustered index? Not the bookish definition, but how they internally works in SQL Server?
What is the difference between primary key and unique constraints?
How can we solve concurrency problems?
What is oltp (online transaction processing)?
What are the main sources of data?
Explain about local stored procedure?
Describe how to use linked server?
Can another user execute your local temporary stored procedures?
What are the recovery models in sql server 2000?
How to generate create view script on an existing view?
What is the size of transaction log file?
Mention a few common trace flags used with sql server?