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?
Uncategorized
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
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 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 blocking and how would you troubleshoot it?
What is blocking and how would you troubleshoot it?
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.
Define candidate key, alternate key, composite key.
Define candidate key, alternate key, composite key
What are defaults? Is there a column to which a default can’t be bound?
A default is a value that will be used by a column, if no value is supplied to that column while inserting data. IDENTITY columns and timestamp columns can’t have defaults bound to them. See CREATE DEFUALT in books online.