Welcome to MSDN Blogs Sign in | Join | Help

March 2006 - Posts

Thursday, March 30, 2006 7:17 PM

Server Side Error Handling - Part 1 (Migrating from @@error to tsql try-catch)

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 necessitated
Posted by NaveenP | 0 Comments
Thursday, March 30, 2006 10:41 AM

Host Policy level Permission Sets and their permissions

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
Posted by RaviR | 0 Comments
Wednesday, March 29, 2006 6:21 PM

Multiplication and Division with Numerics

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 of: .0000006000
Posted by mathh | 1 Comments
Thursday, March 23, 2006 5:41 PM

Newsequentialid (Histrory/Benefits and Implementation)

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/O
Posted by dragant | 10 Comments
 
Page view tracker