What do you mean by an execution plan? How would you view it?


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

Post New Answer

More SQL Server Interview Questions

What is the use of attributehierarchyvisible ? : sql server analysis services, ssas

0 Answers  


What are the transaction properties?

0 Answers  


How do you fine the performance tunning?

2 Answers   Accenture,


What is the tcp/ip port on which sql server runs?

0 Answers  


You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

0 Answers  






Is it possible to create a stored procedure that runs a query and outputs the results to a text file and allows me to add extra delimeters and static field info. If so How?

1 Answers  


what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration

0 Answers  


Do you think BCNF is better than 2NF & 3NF? Why?

0 Answers   Ernst Young,


How do you check the performance of a query and how do you optimize it?

1 Answers  


Can you explain about buffer cash and log cache in sql server?

0 Answers  


What is the data type of time?

0 Answers  


How to find index size for each index on table?

0 Answers  


Categories