What are the different ways of moving data/databases between servers and databases in SQL Server?
What are the different ways of moving data/databases between servers and databases in SQL Server?
Uncategorized
What are statistics, under what circumstances they go out of date, how do you update them?
What are statistics, under what circumstances they go out of date, how do you update them?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
Cursors allow row-by-row processing of the result sets. Types of cursors: Static, Dynamic, Forward-only, Keyset-driven. See books online for more information. Disadvantages of cursors: Each time you fetch a row from the cursor, it results in a network roundtrip, where as a normal SELECT query makes only one rowundtrip, however large the resultset is. Cursors
How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?
How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?
Explain CREATE DATABASE syntax
Explain CREATE DATABASE syntax
Explain CREATE DATABASE syntax Read More »
What are the steps you will take to improve performance of a poor performing query?
What are the steps you will take to improve performance of a poor performing query?
What are the steps you will take to improve performance of a poor performing query? Read More »
What is a deadlock and what is a live lock? How will you go about resolving deadlocks?
What is a deadlock and what is a live lock? How will you go about resolving deadlocks?
What is a deadlock and what is a live lock? How will you go about resolving deadlocks? Read More »
What is blocking and how would you troubleshoot it?
What is blocking and how would you troubleshoot it?
What is blocking and how would you troubleshoot it? Read More »
What is Union, minus and Interact commands?
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
What is Union, minus and Interact commands? Read More »
Define candidate key, alternate key, composite key.
Define candidate key, alternate key, composite key
Define candidate key, alternate key, composite key. Read More »