What is the bookmark lookup and rid lookup?


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

Post New Answer

More SQL Server Interview Questions

Following are some of the question related to below mentioned query? select e1.salary from employee3 e1 where 2= ( select count(distinct(e2.salary)) from employee3 e2 where e2.salary>=e1.salary ) 1) What the query returns? 2) How it works? - Detail explanation (what the sub query does, why it is (where 2=)....etc...Please?

5 Answers  


What are binary string data types in ms sql server?

0 Answers  


How do I trace a query in sql server?

0 Answers  


Mention the different types of replication in sql server.

0 Answers  


What is self contained sub query?

0 Answers  






What are the disadvantages of using the stored procedures?

0 Answers  


Do you know concepts and capabilities of sql server?

0 Answers  


What is self join in sql server joins?

0 Answers  


How do I create a trace in sql server?

0 Answers  


What about UPDATESTATISTICS ?

2 Answers   HCL, Intelligroup,


What happens when transaction log is full?

0 Answers  


How the authentication mode can be changed?

0 Answers  


Categories