What are the tool windows in sql server management studio? : sql server management studio
No Answer is Posted For this Question
Be the First to Post Answer
How to rebuild indexes with alter index ... Rebuild?
How to use the inserted and deleted pseudo tables?
Can you explain full-text query in sql server?
Explain system views?
How to modify an existing user defined function?
What is truncate table?
What is bit data type?
What is a cursor, index in sql?
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.
your distribution database is full what will u do
what are database files and filegroups? : Sql server database administration
Can truncate be rolled back?
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)