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.
1615Well 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 2966
What is SubQuery in SQL Server 2008
What is the difference between a stored procedure and a user defined function?
What is ms sql server reporting services?
Explain about thread and memory management process of SQL?
Is truncate a dml command?
is there a column to which a default can't be bound? : Sql server database administration
Can group functions be used in the order by clause in ms sql server?
Are resultset updatable?
What is data source in connection string?
how can a database be repaired? : Sql server administration
How many null values we can have in a unique key field in sql server?
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
Can we use pragma autonomous_transaction in trigger?
Difference between drill down and drill through report.
How to fetch the next row from a cursor with a "fetch" statement?