Why is my database slow? Ever wonder why software slows down as you enter more data?

One of the important considerations when creating a data-driven application is database performance.  Often, when adequate load testing is not performed, problems are camouflaged because even the poorest database designs are still very fast for small amounts of data. For … Read More

SQL Server Dates – What’s New in SQL Server 2008?

One of the major new features in SQL Server 2008 was a revamping of the date-related data types.  In previous versions, SQL Server only offered datetime and smalldatetime. Datetime supports dates from 1753 until 9999, with precision to approximately one … Read More

SQL Server Denali CTP 3 New Features – Project Crescent, IIF Function, CHOOSE Function

The third community technology preview, or “CTP” of SQL Server Denali was made available for download last week.  It is available for download from Microsoft at http://www.microsoft.com/sqlserver/en/us/future-editions.aspx. According to Microsoft’s blog, this new version now contains all of the features … Read More