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
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 Earls
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
More Premium Content Accessible For Free
Today, business analytics is largely focused on self-service software and pushing business intelligence capabilities down to the end user. In this ...
These days, virtual servers are often seen as time- and money-saving efforts for businesses. When deciding if going virtual is the right thing to do,...
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 ...