What is an execution plan? How would you view the execution plan?


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

Post New Answer

More SQL Server Interview Questions

what is differencial backup?how to work?Anybody explai it?

2 Answers   HCL,


UPDATE statement can on a single table or on the multiple table?

7 Answers   iGate, TCS,


You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

0 Answers  


What are the steps you will take to improve the performance of a poor performing query?

0 Answers  


What are SQL Jobs, please mention the use of it and how to create them.

1 Answers   247Customer,






Can we drop user if user mapped to any logins

1 Answers  


Can we delete data from a view?

0 Answers  


What is the sql server 2000 version number?

0 Answers  


If i have one transaction say mainTransaction, within this mainTransaction i have another two transaction say t1 and t2. Now while execution t1 completes successfully and commit statement fires, but while executing t2 some error occurs and rollback statement fires. What happen to t1, is it rollback or not?

1 Answers   Ness Technologies,


What is an example of a foreign key?

0 Answers  


i need some interview questions on sql server developer plz any onee send some links.

2 Answers  


Where to find ntwdblib.dll version 2000.80.194.0?

0 Answers  


Categories