Get the lowdown on SP-1's added features, including fully supported database mirroring, bug fixes, and add-ons for SQL Express. What's more, SP1 not only contains bug fixes, but also delivers ...

In this third in a series on working smarter with T-SQL, let's give the built-in sp_executesql stored proc a go. In my previous posts, I've described some methods for generating and executing T-SQL ...

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. This article dives into the happens-before ...

Microsoft ratcheted up its product support for SQL Server 2005 by releasing Service Pack 3 (SP3) on Monday, along with SP3 Cumulative Update 1. Microsoft ratcheted up its product support for SQL ...

Available now for about two months, Service Pack 2 is the latest set of bug fixes and enhancements for SQL Server 7.0. Released to the public on March 20, SP2 came out a full eight months after SP1 ...

eWEEK content and product recommendations are editorially independent. We may make money when you click on links to our partners. Learn More. The long wait for the production version of database ...

O SQL Server 2012 SP1 foi lançado com uma ótima melhoria em relação ao XML: índices XML seletivos. Quando utilizados de maneira apropriada, esses índices podem aumentar tremendamente a velocidade de ...

I've inherited a mess.<BR><BR><BR>Part of that mess is that some people have been doing development on the production server, and next week, all that work is going to be erased by the application of a ...

We tested SQL Server, with SP2 installed, on Windows 2000 Advanced Server. Unlike DB2, Oracle9i, and Sybase ASE, SQL Server relies on Windows for clustering. The Enterprise Manager has a graphical ...

Microsoft let it be known this week that Service Pack 2 for SQL Server 2012 will be coming "later this year." Microsoft first released SQL Server 2012 back in April 2012. Service Pack 1 arrived in ...