1.what is the diff between nolock optimizer and read
uncommitted
isolation?
2.what is the diff between revoke and deny?
3.what is percieved down time?
4.whether password protection are required for backups?if
yes why?if no why?
5.what is fill factor?
6.what is cost analysis?
7.what is mean by piece meal restore?
8.what is 'rowguidcol'?
9.impersonate permission?
10.what is selectivity?
how to give input dynamically to a insert statement in sqlserver
What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELECT * FROM EMPLOYEE WHERE EMPID IN (123) WHAT IS THE DIFFERENCE?
How to populate a table in sql server?
Diffrences between sql server 2000 vs 2008
How to find which stored procedure is currently running in sql server?
What is the standby server?
What are primary keys and foreign keys?
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
What is the importance of three tier architecture?
System variable and temporary variables
Tell about MOM Tool(Microsoft Operator Manager)?
What is a recursive stored procedure in sql server?