SQL SERVER Performance Improvement with of Executing Stored Procedure with Result Sets in Denali

Posted by: Journey to SQL Authority with Pinal Dave, on 02 May 2011 | View original | Bookmarked: 0 time(s)

Earlier I posted article SQL SERVER Denali Executing Stored Procedure with ResultSets. After reading this SQL Expert Ramdas asked following and very interesting question: This is a nice feature and i am sure would be used a lot. How is the performance of this as compared with using temp tables? I really loved [...]...

Category: SQL | Other Posts: View all posts by this blogger | Report as irrelevant | View bloggers stats | Views: 770 | Hits: 40

Similar Posts

  • Randomizing LINQ to SQL queries more
  • How to debug a stored procedure in your Sql Server 2005 more
  • Query Notifications and LINQ to SQL - Well I'll be, you *can* do it (with caveats) more
  • Upload Images To SQL Server By Way Of An ASP.NET Web Form more
  • DLinq (Linq to SQL) Performance Part 5 more
  • SQLite, ADO.NET, Prepared Statements, Transactions and Enterprise Manager more
  • Handling "GO" Separators in SQL Scripts - the easy way more
  • Sidetracked with MySQL & SQL Server Performance more
  • Asynchronous command execution in .NET 2.0 more
  • Paging Done RIGHT (in SQL Server 2000 & 2005) more

News Categories

.NET | Agile | Ajax | Architecture | ASP.NET | BizTalk | C# | Certification | Data | DataGrid | DataSet | Debugger | DotNetNuke | Events | GridView | IIS | Indigo | JavaScript | Mobile | Mono | Patterns and Practices | Performance | Podcast | Refactor | Regex | Security | Sharepoint | Silverlight | Smart Client Applications | Software | SQL | VB.NET | Visual Studio | W3 | WCF | WinFx | WPF | WSE | XAML | XLinq | XML | XSD