Data Partitioning in SQL Server was introduced in the 2005 release. This was a feature that had been in Oracle and IBM’s DB2 for a while, but Microsoft is positioning to compete in the VLDB market ...

sQL Server 2008 offers new support for spatial data types that some analysts say should deliver a real boost to geospatial applications and data sharing. Microsoft's soon-to-be-released SQL Server ...

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Vivek Yadav, an engineering manager from ...

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 ...

Backup Compression is also new in SQL Server 2008. Although the compression itself works well, the feature has too many limitations (including supporting only Enterprise Edition) to be effective in an ...

When it comes to Microsoft SQL Server 2008, what can you expect? SQL Server, code named Katmai, is – as its name suggests — due out later this year. Question is why should you care? Now I could talk ...