What is sql sandbox in sql server?
What is page-level compression?
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
Define a cross join?
What are the new security features added in sql server 2012? : sql server security
What does set rowcount do?
Can you explain important index characteristics?
How to apply filtering criteria at group level with the having clause in ms sql server?
What is model database in sql server?
Define the one-to-one relationship while designing tables.
how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }
what is the difference between a primary key and a unique key? : Sql server database administration
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
query processing
What is the use of set nocount on/off statement?