317 reputation
211
bio website aruplab.com
location United States
age 38
visits member for 2 years, 9 months
seen Nov 3 at 16:21

I am a software engineer from Salt Lake City, Utah.

enter image description here


Oct
24
comment Replication fails because of a non-existent foreign key
Thank you for the answer. I don't know that questions ever are really "dead" to new answers on Stack Exchange sites. After a year, asking for more details is bad form, but a new answer is always welcome.
Oct
24
accepted Replication fails because of a non-existent foreign key
Sep
16
asked Performance/Health checking queries for a user with Read permissions
Sep
5
awarded  Popular Question
Jul
2
awarded  Curious
Jun
19
accepted Sequence is reusing
Jun
19
comment Sequence is reusing
Turns out that just setting it with NO CYCLE was enough. (At least it did not happen last night.) Thank you for the help!
Jun
17
comment Sequence is reusing
I thought that there may be transactions causing this. But the Sequence page on MSDN says "Sequence numbers are generated outside the scope of the current transaction. They are consumed whether the transaction using the sequence number is committed or rolled back." So I discarded my transaction theory. I agree there must be something else going on.
Jun
17
comment Sequence is reusing
@AaronBertrand - I agree. I am going to give the NO CACHE thing a go.
Jun
17
comment Sequence is reusing
Well, I can't have it backing up. So if NO CACHE will fix it, then that is what I will do.
Jun
17
comment Sequence is reusing
@AaronBertrand - Well, these values used to come from a legacy system that was just an Int. We did "Cycle" when it hit mid 10 digit range. I just kept that in there. As a BIGINT, the cycle is not really going to happen during my time at our company. I could take it off. (It should not have any effect on this issue though right?)
Jun
17
comment Sequence is reusing
@MartinSmith - I updated my question with an answer to your comment.
Jun
17
comment Sequence is reusing
@AaronBertrand - I updated my question with answers to your comments.
Jun
17
revised Sequence is reusing
added 959 characters in body
Jun
16
revised Sequence is reusing
edited body
Jun
16
asked Sequence is reusing
May
19
accepted Permissions to see and script objects, but not alter them?
May
19
asked Permissions to see and script objects, but not alter them?
Jan
17
comment Why is SQL Server using a clustered index scan for a self referencing FK cascade delete
Thanks! I had a few indexes missing from my table. When I added all 3 the delete went from 57 seconds to less than a second!
Jan
17
comment Why is SQL Server using a clustered index scan for a self referencing FK cascade delete
@AaronBertrand - OK, thanks!