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
Comments are closed.
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
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.
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