Tag: Parameterized Queries

By Posted on Posted in SQL 2012, SQL Saturday, TSQL, TSQL 2012 2 Comments Tagged with , , , , , , , ,

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 information about what the results will look like.  sp_describe_first_result_set is an alternative to sp_columns, and appears to perform much better than sp_columns. The information here has been extracted from my SQL Saturday presentation on Whats New in TSQL …

T-SQL 2012 Procedure sp_describe_first_result_set Read more »

By Posted on Posted in DBA No Comments Tagged with , , , ,

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 on Oracle. The following is something that I have discovered to be very similar between Oracle and Microsoft SQL Server, but the names are different between the two systems. So this brings me back to …

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