Pulse » Popular
SET SHOWPLAN ON
Use SET SHOWPLAN_XML instead of SET SHOWPLAN_TEXT or SET SHOWPLAN_ALL. Microsoft announced at the SQL Server 2008 release , SET SHOWPLAN_TEXT and SET SHOWPLAN_ALL are deprecated The advantage of using SET SHOWPLAN_XML ON is that the code is not executed. Executing the t-sql returns the execution plan. SET SHOWPLAN_XML ON ...
Pulse is a brand-new section of SQLServerPedia that gives you a quick view of what's happening in the SQL Server community. We recommend checking out Pulse in a modern web browser, such as Internet Explorer 7+, Firefox 3+, Safari 4+, Opera 10+, or Chrome.
