Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

Learn about SQL Server DBA, SQL Server database performance,SQL Server optimisation,database tuning,t-sql,ssis
Browse by Tags · View All
DBA Scripts 51
performance 37
SQL Server 29
Object Management 24
#SQLServer 24
Backup and Restore 20
Security Management 20
Powershell 17
Indexes 14
DBA 14

Archive · View All
June 2011 38
January 2011 33
May 2011 32
August 2011 27
July 2011 26
January 2012 24
February 2011 19
April 2011 19
March 2011 17
March 2012 17

Jack Vamvas's Blog

SQL Server sql_handle returns sql statement

Jul 18 2011 5:34AM by Jack Vamvas   

Certain Dynamic Management Views(DMV) return a sql_handle column.

Examples of DMVs returning the sql_handle column are:

sys.dm_exec_query_stats

sys.dm_exec_requests

sql_handle is a varbinary(64). A varbinary is suitable for variable length binary data. The sql_handle is a token referencing a stored procedure or batch.

The table-valued function sys.dm_exec_sql_text returns the text of the sql_handle. It has a parameter: @handle (varbinary(64))

-- returns sql query text referencing aggregate performance statistics

-- on sys.dm_exec_query_stats.

select sql_handle,(SELECT TOP 1 SUBSTRING(s2.text,statement_start_offset / 2+1 ,

      ( (CASE WHEN statement_end_offset = -1

         THEN (LEN(CONVERT(nvarchar(max),s2.text)) * 2)

         ELSE statement_end_offset END)  - statement_start_offset) / 2+1))  AS sql_statement from sys.dm_exec_query_stats

CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS s2 

Republished from http://www.sqlserver-dba.com.


Republished from SQL Server DBA [65 clicks].  Read the original version here [32134 clicks].

Jack Vamvas
5 · 26% · 8528
0
Liked
 
0
Lifesaver
 
0
Refreshed
 
0
Learned
 
0
Incorrect



Submit

Your Comment


Sign Up or Login to post a comment.

    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]