What are the different acid properties?
How many triggers are possible per table?
What is indexing a document?
What is “asynchronous” communication in sql server service broker?
Explain about temporary stored procedure?
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
How many types of functions are there in sql server?
What is the difference between a stored procedure and a user defined function in sql server?
How do I clean up sql server transaction log?
Define clusters?
What is the use of placing primary key and foreign key constrains on columns.
what's the difference between a primary key and a unique key? : Sql server database administration
What are indexes in ms sql server?