How many types of subqueries are there in sql server?

986

Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

1155

How to include text values in sql statements?

1031

Write a SQL query to delete a table?

1132

Explain what is the function of sql server agent windows service?

990

What are the approximate numeric data types?

923

what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

1016

What is encryption key?

130

What is update locks?

879

What is use of except clause? How does it differ from not in clause?

1015

What is rolap and its advantage? : sql server analysis services, ssas

1277

How to view the error log for any specific instance? : sql server database administration

1031

Explain can you implement data mining in ssrs?

158

you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration

944

How to end a stored procedure properly in ms sql server?

1081