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
What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?
What is scrollable cursor?
How to test values returned by a subquery with the in operator?
can primery key be a non clustered index?
Why I can not enter 0.001 second in date and time literals in ms sql server?
What does it mean to manipulate data?
How to download and install the scaled-down database adventureworkslt?
What is a NOLOCK?
1. What is CUBE Operator? 2. what are the new data types are available in sql server 2008? 3. Inisde a nested queries, how many subqueries u can have?
What is database isolation in sql server? : sql server database administration
how to get max salary with employee number by using one select query and max function ??
Explain sql delete command?
Oracle (3259)
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)