Browse by Tags

Conditional Failed because the followng SET operations has incorrect settings: 'ARITHABORT'

Published 16 July 7 3:10 AM | SSQA.net

I got this error when trying to drop and create an index on a table. Create failed for index IX_USER_ID (Microsoft.SQLServer.Smo) Additional Information An exception occured while executing a transact sql statement or batch (Microsoft.SQLServer.ConnectionInfo...

Filed under: sql server, indexes, compiled, stored procedure, tsql, arithabort

Knowing about performance impact of simple use of procedures

Published 13 July 7 9:42 AM | SSQA.net

If you ask an experience DBA about the reasons for performance loss then the answer should be straight to look for SQL Server, Operating System and hardware counters for further investigation. Simultaneous access to shared resources causes bottlenecks...

Filed under: sql server, performance, dmv, compiled, impact, stored procedure, compression