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

What is an active database?

0 Answers   HCL,


Which are the third-party tools used in sql server and why would you use them?

0 Answers  


How do we get current date in SQL Server 2000, Oracle, MS Access?

13 Answers  


Do you know what is xpath?

0 Answers  


How to enter unicode character string literals in ms sql server?

0 Answers  






Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

0 Answers  


what are the different ways to return the rowcount of a table?

0 Answers   Microsoft,


Explain transaction server isolation?

0 Answers  


How maney row would be print after join if A table have 100 rows and B table have 50 rows...

9 Answers   Hewitt,


what is the primary use of the model database? : Sql server administration

0 Answers  


How many full-text indexes can a table have?

0 Answers  


Why do we use functions?

0 Answers  


Categories