asking for situation of query

Last Post 10 Oct 2010 11:04 PM by m k. 6 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
m k
New Member
New Member

--
06 Oct 2010 03:12 AM
Hi all. I am a c# programmer in asp.net. I have a hage update query that effects very very record. this query needs 30 minutes time for execute (in each reasons).
my question is: I want to see query situation and find how many records are affected in every 30 seconds. what should I do? Is it possible to do this? do query or trigger says his situation with us?
rm
New Member
New Member

--
06 Oct 2010 03:53 PM
If you update with smaller batches, may able to check @@rowcount.
m k
New Member
New Member

--
06 Oct 2010 11:07 PM
Yes I know. But my query is not executed completely yet. for example my big query need 2 min time. I want to find that how many records are affected after 30 seconds?
gunneyk
New Member
New Member

--
08 Oct 2010 01:57 PM
There is no way to see if it is a single Update statement. If you need that level of granularity then do as rm suggested and update in smaller batches.
m k
New Member
New Member

--
08 Oct 2010 08:15 PM
Thanks for reply.
Could you write a sample please and explain more?
Thank you again.
gunneyk
New Member
New Member

--
10 Oct 2010 12:24 PM
Well it depends on what you are trying to do and what the tables look like etc. If you post the Update statement we can have a look.
m k
New Member
New Member

--
10 Oct 2010 11:04 PM
I have a huge update query that effects very very record.
You suppose each you think. It's not important.
Just say how?
And write a sample each you like.
You are not authorized to post a reply.

Acceptable Use Policy