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.
2508Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?
2 4706
What is blocking?
Why we should not use triggers?
How to make conditional sum in ssrs?
What is a subquery in a select query statement in ms sql server?
Who developed sql server?
What is logon trigger?
What is primary key and example?
What is a not null constraint?
Define constraints and give an example of their use?
Explain system rowset functions?
Do you know what are the properties of the relational tables?
What is a performance monitor?
What is openrowset sql server?
What is the server name in sql server?
What are wait types?