What is the dbcc command and why is it used?
what kind of lan types do you know? : Sql server database administration
How to rebuild all indexes on a single table?
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
What is meant by dirty read?
How to defragment table indexes?
Explain nested trigger in sql?
What are .mdf files?
i have a table student like sname ----- ram ram ram raj raj raj i need the output like sname ----- ram raj ram raj ram raj
What is difference between rollback immediate and with no_wait during alter database?
How do you clear a log file?
Does group by or order by come first?
What is policy management?