Search Results | SQL Server Performance Forums

Table operations too slow.

Post by: GRKool, Jun 21, 2007 in forum: SQL Server 2005 T-SQL Performance Tuning

Hi All, The problem got resolved. The DBA could figure it out. It occured because of the locks on tableA. Some jobs were running in the background...

Table operations too slow.

Post by: GRKool, Jun 21, 2007 in forum: SQL Server 2005 T-SQL Performance Tuning

quote:Originally posted by Adriaan Do you have a maintenance job scheduled to optimize the indexes? Not very sure; but couldn't see any.

Table operations too slow.

Post by: GRKool, Jun 21, 2007 in forum: SQL Server 2005 T-SQL Performance Tuning

Ohh .. okay. Its just few months I have started with SQL server; so trying each and every that comes in mind; so thought of trying execution plan as...

Table operations too slow.

Post by: GRKool, Jun 21, 2007 in forum: SQL Server 2005 T-SQL Performance Tuning

Is this a parent table with cascade delete to other tables? - No. But similar kind of thing is handled through triggers. Does the table have...

Table operations too slow.

Post by: GRKool, Jun 21, 2007 in forum: SQL Server 2005 T-SQL Performance Tuning

quote:Originally posted by Madhivanan Run the profiler and see if there are any blocks How many rows do you expect to be deleted? If there are too...

Table operations too slow.

Post by: GRKool, Jun 20, 2007 in forum: SQL Server 2005 T-SQL Performance Tuning

I am not getting any error for this. The records are successfully getting inserted into the table through simple INSERT statement. But further...

Table operations too slow.

Thread by: GRKool, Jun 20, 2007, 11 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

My table already had few millions of records. Few thousand records have got inserted into this table during performance testing. Now, the table is...

INSERT operation too slow.

Post by: GRKool, Jun 20, 2007 in forum: SQL Server 2005 T-SQL Performance Tuning

Okay, Thanks everyone .. !

INSERT operation too slow.

Post by: GRKool, Jun 18, 2007 in forum: SQL Server 2005 T-SQL Performance Tuning

Ohh .. I mis-interpreted the error it seems :-(<br />You are right; this worked perfectly fine and I can see the performance improvement as well. The...

INSERT operation too slow.

Post by: GRKool, Jun 18, 2007 in forum: SQL Server 2005 T-SQL Performance Tuning

quote:Originally posted by Madhivanan Why didnt you use the method I suggested? Madhivanan Failing to plan is Planning to fail Can you please...

INSERT operation too slow.

Post by: GRKool, Jun 17, 2007 in forum: SQL Server 2005 T-SQL Performance Tuning

This is original code which is pretty slow - (specifically the INSERT statement)....

INSERT operation too slow.

Post by: GRKool, Jun 16, 2007 in forum: SQL Server 2005 T-SQL Performance Tuning

quote:Originally posted by DilliGrg quote:Originally posted by GRKool Here, table A is too large and INSERT is performed record by record; which...

INSERT operation too slow.

Post by: GRKool, Jun 16, 2007 in forum: SQL Server 2005 T-SQL Performance Tuning

quote:Originally posted by Madhivanan Dont use Cursor General Approach Update T set col=S.col from TargetTable T inner join SourceTable S on...

INSERT operation too slow.

Thread by: GRKool, Jun 15, 2007, 12 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

My code reads records from table A in a cursor one by one. Read record - @emp_id { If the record (@emp_id) exists in table B, Update the record with...