Tsql try-catch was added to improve server side error handling in sql server 2005. This feature should have been part of early T-Sql. Better late than never. In absence of tsql try-catch, server-side error handling was done using @@error. This had...

While there is guidance on how to use the various permission sets - SAFE, EXTERNAL_ACCESS, UNSAFE , a list of the various permissions granted in these three helps clear their definitions. SAFE: Code that has this permission set is only allowed to execute...

It can be surprising to see certain results when doing numeric arithmetic: declare @num1 numeric(38,10) declare @num2 numeric(38,10) set @num1 = .0000006 set @num2 = 1.0 select cast( @num1 * @num2 as numeric(38,10)) Yields: .0000010000 Instead...

In general, we made significant improvements in SQL Server scalability during Yukon . One of the areas of improvement is replication scalability. While doing merge replication testing we found out that scaling was severely affected by high number of I...