What is User Defined Functions? What kind of User-Defined Functions can be created?
What is User Defined Functions? What kind of User-Defined Functions can be created? Read More »
What are the different ways of moving data/databases between servers and databases in SQL Server?
What are statistics, under what circumstances they go out of date, how do you update them?
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?
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? 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? Read More »
What is blocking and how would you troubleshoot it?
What is blocking and how would you troubleshoot it? Read More »
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 »