Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 0 Answers
- 2508 Views
- iSoft, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
How do I view a script in sql server?
How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.
What are different types of Keys? Please explain all the keys with a suitable example.
What are ddl triggers and types of ddl trigger?
How to download and install microsoft sql server management studio express?
What is Extended user-defined?
Do you know what is difference between index seek vs. Index scan?
here id col have primary key and identity id name 1 a 2 b 3 c 4 d delete 2nd row then o/p will be id name 1 a 3 c 4 d next inssert 2nd row and i want o/p will be id name 1 a 2 e 3 c 4 d
What is the meaning of resultset type_scroll_insensitive?
When multiple after triggers are attached to sql table, how to control the order of execution?
How to loop through result set objects using odbc_fetch_row()?
According to you what goes into making the best database administrator? : sql server database administration
-
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)
