Category Archives: SQL Server 2005 improvements

Error Hadling: Using TRY…CATCH in Tsql.

Error Handling: Using TRY…CATCH in Transact-SQL   Errors in Transact-SQL code can be processed by using a TRY…CATCH construct similar to the exception-handling features of the Microsoft Visual C++ and Microsoft Visual C# languages. A TRY…CATCH construct consists of two … Continue reading

Posted in SQL Server 2005 improvements | 100 Comments

Reducing Database Size by Using VarDecimal datatype

Reducing Database Size by Using Vardecimal Storage Format The vardecimal storage format became available starting with Microsoft SQL Server 2005 Service Pack 2 (SP2) in the Enterprise Edition. This storage format can be enabled at a table-level granularity. When enabled, … Continue reading

Posted in SQL Server 2005 improvements | 25 Comments