Presenting "What's New in SQL Server Denali" for WVPASS
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
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
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.
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;';
its similar to the work around to get object_ids for temp tables