SQLBlog

Presenting "What's New in SQL Server Denali" for WVPASS

Aaron Bertrand ·

Recently I was asked by John Sterrett (blog | twitter) to present to his SQL Server user group (WVPASS) in Wheeling, West Virginia. Well, today is the day, and I will be presenting, "What's new in SQL Server Denali" at tonight's meeting, sponsored by SQL Sentry. The slide deck is attached below; the samples are available here.

If you attended this presentation, please feel free to provide feedback at SpeakerRate.

 

File Attachment: Demos_Snippets.zip

Aaron Bertrand

I am a passionate technologist with industry experience dating back to Classic ASP and SQL Server 6.5. I am a long-time Microsoft MVP, speak frequently at conferences, and write at SQLPerformance and MSSQLTips. I recently joined the team at Wayfair and hope to blog about some of the scale challenges I've already started helping to solve.

3 Responses

  1. Julian Kuiters says:
    March 18, 2011 at 4:18 AM

    Hi Aaron,
    I noticed in your MetaDiscovery.sql Demo 3 you say it does not work for temp tables…..
    What if you use:
    EXEC tempdb.sys.sp_describe_first_result_set N'DECLARE @x TABLE(i INT);SELECT i FROM @x;';
    EXEC tempdb.sys.sp_describe_first_result_set N'CREATE TABLE #y (j INT);SELECT j FROM #y;';
    GO
    its similar to the work around to get object_ids for temp tables

  2. AaronBertrand says:
    March 18, 2011 at 5:20 AM

    Hi Julian, in this case it's not about location, it's about literal parsing. With the tempdb prefix I get the same error:
    Msg 11525, Level 16, State 1, Procedure sp_describe_first_result_set, Line 1
    The metadata could not be determined because statement 'SELECT j FROM #y;' uses a temp table.

  3. Julian Kuiters says:
    March 18, 2011 at 5:33 AM

    Ah thanks Aaron
    I'm looking forward to getting my hands on Denali – quite a few of the new functionality shown in your demo scripts would be really useful on my projects