Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
How do you simulate a deadlock for testing purposes
how to write the query to select the rows are in the order of either 1,3,5,7... or 2,4,6,8,...
7 Answers ADP, Satyam, Tech Mahindra,
Explain primary key, foreign key and unique key?
What is Transaction?
Define normalisation?
What is a recursive stored procedure in sql server?
Write an SQL query to obtain the 2nd highest salary.
0 Answers Akamai Technologies,
How to check what was the last restore transaction LSN on Log-Shipping and Mirroring when we doesn't have a Monitor server and Witness server?
Explain how to maintain a fill factor in existing indexes?
Is foreign key unique?
How do we know if any query is retrieving a large amount of data or very little data?
What is molap and its advantage? : sql server analysis services, ssas