what stored procedure would you use to view lock information? : Sql server administration
how to find maximum identity number in a table ?
2 Answers JPMorgan Chase, Thomson Reuters, Wipro,
What are different types of Keys? Please explain all the keys with a suitable example.
How do you start single user mode in clustered installations?
What is database white box testing?
How can we improve performance by using SQL Server profiler?
you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation
Explain primary key in sql server?
Display a roll having miminum marks in two subjects?
How to use values from other tables in update statements in ms sql server?
what is the difference between count(*) and count(1) ?
Mention the different authentication modes in sql server.
Do you know what is bit data type and whats the information that can be stored inside a bit column?