Access your Pro+ Content below.
SQL Server stored procedures supercharged in recent, upcoming versions
This article is part of the December 2011, Vol. 8 issue of SQL Server Insider
SQL Server stored procedures are Transact-SQL (T-SQL) statements or references to the common language runtime in Microsoft’s .NET framework that are designed to make database querying easier. They accept input parameters, return output parameters and perform operations including SELECT, INSERT, UPDATE and DELETE in the database. Stored procedures provide a number of benefits, from reducing network traffic to reusing cached execution plans and providing increased security and improved ease of maintenance. SQL Server 2008 introduced a slew of features that offer a significant boost in stored-procedure performance over its earlier counterpart, SQL Server 2005. Almost three years later, 2008 R2 was rolled out with just a few minor tweaks to stored procedures. SQL Server 2012, which will be released sometime this year and is now available in a release candidate version, packs a number of its own performance-boosting additions. Stored procedures today One of the biggest stored-procedure improvements in SQL Server 2008 and 2008 R2 ...
Features in this issue
Microsoft is forever tinkering with SQL Server stored procedures to give queries more thrust. Find out what’s new in SQL Server 2008, 2008 R2 and the next-generation 2012 release.
News in this issue
With tool sets still evolving, developers face stiff challenges in integrating data in hybrid SQL Server-SQL Azure environments.
SQL Server data warehousing may have seemed a misnomer a few years ago. But many Microsoft shops with growing data needs are seeing the benefits of native products.