Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / swapna
DBCC CHECKDB, DBCC CHECKTABLE, DBCC CHECKCATALOG, DBCC
CHECKALLOC, DBCC SHOWCONTIG, DBCC SHRINKDATABASE, DBCC
SHRINKFILE etc. But there are a whole load of DBCC commands
which are very useful for DBAs.
| Is This Answer Correct ? | 16 Yes | 2 No |
Post New Answer View All Answers
How to link tables in sql server?
Mention a few common trace flags used with sql server?
How many database files are there in sql server 2000?what are they?
How to use values from other tables in update statements in ms sql server?
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
What is the difference between substr and charindex in the sql server?
How to execute a sql statement using odbc_exec()?
How many types of relations are there between dimension and measure group? : sql server analysis services, ssas
Is port 1433 secure?
Write a SQL query to delete a table?
How to disable triggers using "disable trigger"?
How to sort the query output with order by clauses in ms sql server?
what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration
what is the difference between count(*) and count(1) ?
Can a database be shrunk with users active?
