Explain syntax for viewing, dropping and disabling triggers?
Will sql server 2005 allow you to reduce the size of a column?
How to find the second highest salary of an employee?
What is lock escalation?
How to create new databases with "create database" statements?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
How to stop a loop early with break statements in ms sql server?
select the 3rd maximum salary from sql server database if 4 (just an example In practically I may not know the exact situation) of the highest salaries are equal.
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?
What are the differences between stored procedure and view in sql server?
Define primary key?
How to create a large table with random data for index testing in ms sql server?
What do you understand by a stored procedure?