By Saravanan Radhakrishnan, 01/26/2012
Loading new data and purging old data from a table can take a lot of time if a large amount of data is involved. Here's an elegant partition solution that loads and purges data ...
By Kalen Delaney, 01/19/2012
Learn how you can replace a scalar-valued user-defined functions (UDFs) call with actual code to greatly improve SQL Server performance.
By Kalen Delaney, 12/29/2011
Kalen discusses two reasons she finds SQL Server query hints to be fascinating.
By Brian Moran, 12/22/2011
The SQL Server community is known for banding together to help those in need, whether they have a SQL Server-related question or a charity they want to support. Here's two acts of ...
By Blair Greenwood, 12/21/2011
Check out the latest database administration products in the SQL Server market from Attunity, Idera, and expressor software.
By Bob Beauchemin, 12/14/2011
Because a data-tier application (DAC) is instance-independent and version-independent, you can create a package—an .msi file equivalent—to move database schema (and soon data) to ...
By Michael Otey, 12/12/2011
SQL Server is a mission-critical and enterprise-ready database for a variety of reasons, including price, performance, and BI.