Parameterized Queries

T-SQL 2012 Procedure sp_describe_first_result_set

by SteveStedman
April 5, 2013April 5, 2013
2 Comments
SQL 2012, SQL Saturday, TSQL, TSQL 2012

SQL Server 2012 adds a new stored procedure called sp_describe_first_result_set. This new procedure returns metadata for the result set returned from a query. The metadata is… Read More »T-SQL 2012 Procedure sp_describe_first_result_set

How much Procedure Cache memory does one SQL Statement take up?

by SteveStedman
September 17, 2008November 25, 2011
1 Comment
DBA

I recently have had the opportunity to work on performance tuning on Microsoft SQL Server 2005. Recently I have been doing more with performance tuning… Read More »How much Procedure Cache memory does one SQL Statement take up?