🤚

Jared Dobson jaredmdobson

🤚

Data Engineer

jaredmdobson / sp_queryplan.sql

Created January 13, 2012 01:50

SQL Server 2008 Shows Execution Plan for a given spid.

	--=====================================================
	-- Author: Jared Dobson
	-- Date: 12/22/2010
	-- Description: Shows Execution Plan for a given spid.
	--=====================================================
	CREATE PROCEDURE sp_queryplan ( @SessionID INT )
	AS
	BEGIN
	SELECT
	[DEQP].[query_plan],

jaredmdobson / EnableAllTriggers.sql

Created January 13, 2012 01:48

T-SQL Enable All Triggers

	CREATE PROCEDURE [dbo].[EnableAllTriggers]

	AS

	DECLARE @string VARCHAR(8000)

	DECLARE @tableName NVARCHAR(500)

	DECLARE cur CURSOR