3,260 reputation
918
bio website
location
age
visits member for 2 years, 5 months
seen 1 hour ago

Huge fan of SQL Server, I've been searching for opportunities to work on more MSSQL projects which is why I'm here.

I have been working in mixed environments with a combination of MySQL, PostgreSQL, LDAP and SQL Server for the past 15 years.


Apr
8
comment What do spikes in InnoDB lock structures indicate?
Download the free version of Jet Profile jetprofiler.com/download, it will store the information for later viewing so you can keep it running overnight. Might shed some more light on what's causing the increased locking
Apr
8
comment What do spikes in InnoDB lock structures indicate?
Are you sure a backup or some other scheduled task isn't happening at the same time as your spikes?
Apr
7
comment Detecting changes in a SQL Server table
Makes sense, even if I don't really feel like I'm cheating using SQL servers views.
Apr
7
comment Detecting changes in a SQL Server table
So why would Microsoft bother creating sys.dm_db_index_usage_stats, if the information its providing can't be relied upon?
Apr
4
comment Most efficent DELETE Method
Hello @ypercube. Removed the include columns from the nci's and ended up staying with the deletion by batch. Which was the third method in the question. Thank you for the assist. If you put your comment in an answer, I will check it off.
Apr
3
revised Most efficent DELETE Method
added 477 characters in body
Apr
3
asked Most efficent DELETE Method
Mar
27
comment Is there anyway to make this stored procedure thread safe?
Hello Bob, duly noted. Thanks also for the test environment you provided and ostress. Very helpful in testing the various versions of the stored procedure above, including yours.
Mar
27
comment Is there anyway to make this stored procedure thread safe?
Well your solution worked, however vague you feel your answer may have been. Its up to you if you want credit or not ofcourse, as your suggestion about READPAST solved the deaklocking problem of this particular stored procedure.
Mar
27
comment Is there anyway to make this stored procedure thread safe?
Hello, I did fully test using your proposed alternative stored procedure and did from time to time run into deadlocks. They were rolled back by the CATCH you included and then the deletion process continued normally. Is this normal?
Mar
26
revised Is there anyway to make this stored procedure thread safe?
added 794 characters in body
Mar
26
comment Is there anyway to make this stored procedure thread safe?
Thanks for adding that. After some testing, it turns out the READPAST solution was the best option. I'll add some comments to my question to explain why.
Mar
26
comment Is there anyway to make this stored procedure thread safe?
Hello @JonSeigel. The readpast solution worked the best out of them all and required the least amount of modification. If you put your comment in an answer, I will check it off. thanks again for the assist.
Mar
26
comment Is there anyway to make this stored procedure thread safe?
Hello, can you send me the test rig? Thanks in advance
Mar
25
revised Is there anyway to make this stored procedure thread safe?
added 98 characters in body
Mar
25
comment Is there anyway to make this stored procedure thread safe?
Hello @JonSeigel, I will send the deadlock graph shortly.
Mar
25
asked Is there anyway to make this stored procedure thread safe?
Mar
21
accepted Can't update trigger because of activity
Mar
21
comment Can't update trigger because of activity
Hello @JonSeigel, thank you for the hint, but basically even with the deaklock priority set higher for my session, I was still unable to get to a point where I had access to the table.
Mar
20
comment Can't update trigger because of activity
I wish a maintenance window were possible, but lets just assume that someone did something in production that needs to be rolled back. Guess they will have to wait and deal with the consequences.