What is an active database?
How do you use DBCC statements to monitor various aspects of a SQL server installation?
Explain the cursor lock types?
How to get the definition of a user defined function back?
What is 1nf 2nf?
What does indexation mean?
How to Run a Query on a Remote SQL Server?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
Issues related in upgrading SQL Server 2000 to 2005 / 2008
How to Get the last identity value used
What does set rowcount do?
Does hive support indexing?
Do you know what is replace and stuff function in sql server?