SQL Server Performance

Query Execution Plans security and new feature within SQL Server 2008 Management Studio

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Mar 4, 2008.

  1. Anonymous New Member

    If there is any performance issue within your queries then looking at query execution plan is the first step towards assessing the loss, you may be aware that execution plans of queries and queries on partitioned tables and indexes can be examined by using the TSQL SET statements such as SET SHOWPLAN_XML or SET STATISTICS XML, or by using the graphical execution plan output in SQL Server Management Studio. There are 2 methods of taking into execution plan for a query such as display the compile-time...(<a href="http://sqlserver-qa.net/blogs/sql2008/archive/2008/03/04/3692.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=3692" width="1" height="1">

Share This Page