What is the difference between index seek vs. Index scan?


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

Post New Answer

More SQL Server Interview Questions

What do you mean by recursive stored procedure?

0 Answers  


What is stretch database in sql server?

0 Answers  


There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 Answers  


What is default constraint in ms sql server?

0 Answers  


What is a benefit of using an after insert trigger over using a before insert trigger?

0 Answers  






How to work on DTS?what is the main requirement?

1 Answers   Getit, ivan,


i have a table #temp1(id, Name groupname ) and record like this 1 R1 S 2 R3 S 3 R2 S 4 R4 D 5 R5 D 6 R6 K 7 R7 K 8 R8 L 9 R9 L 10 R10 L 11 R11 K and i want to display record based on user defind sorting order e.g. 1 R4 D 2 R5 D 3 R6 K 4 R7 K 5 R11 K 6 R1 S 7 R3 S 8 R2 S 9 R8 L 10 R9 L 11 R10 L

8 Answers  


What is clustered vs nonclustered index?

0 Answers  


What do you mean by SQL injection attack?

0 Answers   Ittiam Systems,


How many database files are there in sql server 2000?what are they?

0 Answers  


Consider the table T1 it consits A,2,3,4 consider another table t2 it contain 1,2a,3a,4a now i need o get the upadted answer

3 Answers  


what is denormalization? : Sql server database administration

0 Answers  


Categories