Access "SQL Server stored procedures supercharged in recent, upcoming versions"
This article is part of the December 2011, Vol. 8 issue of Azure Cloud testing tips for SQL Server shops
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 is table-valued parameters. ... Access >>>
Premium Content for Free.
SQL Server stored procedures supercharged in recent, upcoming versions
by Richard Ding, Contributor
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.
- SQL Server stored procedures supercharged in recent, upcoming versions by Richard Ding, Contributor
For SQL Server shops testing Azure cloud, it’s all about integrating data
by Beth Stackpole, Contributor
With tool sets still evolving, developers face stiff challenges in integrating data in hybrid SQL Server-SQL Azure environments.
Cost, proliferation power rise of SQL Server data warehousing
by Alan R. Earls, Contributor
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.
- For SQL Server shops testing Azure cloud, it’s all about integrating data by Beth Stackpole, Contributor
More Premium Content Accessible For Free
Microsoft has made a great effort to turn SQL Server into a viable enterprise database platform, and part of that has been boosting its business ...
Are you going to upgrade to SQL Server 2012? This edition of SQL Server Insider sets out to help you decide whether the investment is worth it or not...
Everyone knows SQL and NoSQL technologies don't co-exist well. But can they? Check out Issue 3 of SQL Server Insider E-Zine to find out about the ...