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
What is the use of attributehierarchyvisible ? : sql server analysis services, ssas
What are the transaction properties?
How do you fine the performance tunning?
What is the tcp/ip port on which sql server runs?
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?
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?
what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration
Do you think BCNF is better than 2NF & 3NF? Why?
How do you check the performance of a query and how do you optimize it?
Can you explain about buffer cash and log cache in sql server?
What is the data type of time?
How to find index size for each index on table?