Browse by Tags

All Tags » compiled   (RSS)
Conditional Failed because the followng SET operations has incorrect settings: 'ARITHABORT'
16 July 07 01:10 AM | SQL Master | 1 Comments   
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) Read More...
Knowing about performance impact of simple use of procedures
13 July 07 07:42 AM | SQL Master | 1 Comments   
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. Read More...
SQL Server 2005: Stored Procedure call activity statistics & execution time
21 June 07 02:56 PM | SQL Master | 1 Comments   
Is it possible to get statistics like how many times a stored procedure is called such as average execution time and how often that procedure is being called. Bascially it is possible to get provided that particular stored procedure is active and plan Read More...