126 reputation
3
bio website
location
age
visits member for 1 year, 9 months
seen May 7 at 22:36

Dec
11
awarded  Popular Question
Nov
2
comment What can I do to speed up this SQL Query?
I'll look at your suggestion in more detail on Monday, right now I'm up to 90 seconds with another update (required) I'll post that later and see what I can do to speed that up too... thanks
Nov
2
comment What can I do to speed up this SQL Query?
I'll post my results on Monday once I've had chance to go through this with the full record set.
Nov
1
comment What can I do to speed up this SQL Query?
@010001100110000101110010011010 - There are usually about 2/10k records in there. If you tell me how you want execution time logged I'll set it up....
Oct
30
comment What can I do to speed up this SQL Query?
@MichaelJSwart - See update, times have been improved, I've posted the query plan to see if there are other improvements I can make.
Oct
30
awarded  Editor
Oct
30
revised What can I do to speed up this SQL Query?
added 4947 characters in body
Oct
30
comment What can I do to speed up this SQL Query?
@MichaelJSwart Would I need to run the query again to get the query plan? I can run it again if I need to, but at 30 minutes it's using up all of the server's resources so I'd like to avoid it, if at all possible.
Oct
30
awarded  Student
Oct
30
asked What can I do to speed up this SQL Query?