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?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

how to give input dynamically to a insert statement in sqlserver

3 Answers   HCL,


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?

15 Answers   Adsys, Cap Gemini,


How to populate a table in sql server?

0 Answers  


Diffrences between sql server 2000 vs 2008

0 Answers   TCS,


How to find which stored procedure is currently running in sql server?

0 Answers  






What is the standby server?

0 Answers  


What are primary keys and foreign keys?

4 Answers  


How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

0 Answers  


What is the importance of three tier architecture?

0 Answers   QuestPond,


System variable and temporary variables

0 Answers   Wipro,


Tell about MOM Tool(Microsoft Operator Manager)?

0 Answers  


What is a recursive stored procedure in sql server?

0 Answers  


Categories