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
Is sql server is free?
Explain cross join or cartesian product in sql?
When I run the sql server 2000 setup, it just hangs. What do I do?
What are primary keys and foreign keys?
Explain why variables called the most powerful component of ssis?
About DTS usage ?
What is the differecne between equi-join and inner-join and natural join..Is there any difference or all are same?
What are the advantages of using cte?
Can foreign key be duplicate?
what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration
How to transfer data from a cursor to variables with a "fetch" statement?
What is INTVAL( )and where we use Plz any body help me
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)