Explain what is lock escalation and what is its purpose?
No Answer is Posted For this Question
Be the First to Post Answer
Explain log shipping and mention its advantages.
What information is maintained within the msdb database?
When would you prefer to have a minimum number of indexes?
What are types of scd? : sql server analysis services, ssas
Explain a join?
what are default? Is there a column to which a default cant be bound?
What are the benefits of normalization?
What are the differences between union, intersect, and minus operators?
if 3 duplicate records in a table,i want to delete 2 duplicate records by keeping 1 duplicate and 1 original as it is,how?
How do you test your database? : sql server database administration
What is dbcc? Give few examples.
Describe in brief system database.