Viewing 15 posts - 16 through 30 (of 34 total)
Hi Frederic.
I do indeed have a solution! It ended up on a parallel thread. That dogged me for a long time. Hope this helps.
-Dave
------
Looks like I've got...
October 4, 2013 at 10:33 am
Looks like I've got a solution!
If you are experiencing problems with a SEQUENCE resetting to a lower value, disable CYCLING. When I did this, I was able to leave...
February 19, 2013 at 3:02 pm
Thanks for the info on the foreign keys.
Aside from the automatic clustered index, any thing special about an actual Primary Key Constraint versus a Unique Constraint?
January 31, 2013 at 4:14 pm
Thanks Dwightrau. Unfortunately I'm not in a position to redeploy. 🙁 Interesting that this fixed it for you. You actually dropped the dB and rebuilt it from scratch...
January 31, 2013 at 10:37 am
I believe the $900 includes a coupon for a 15% discount off the exam.
January 9, 2013 at 9:44 pm
After seeing no problems with NOCACHE, I bumped the cache up to 10. The problem returned and I noticed that the value the sequence is "resetting" to the value...
January 8, 2013 at 11:36 am
I continued to have this problem for several days, the SEQUENCE somehow "resetting" to a lower value.
I was caching the SEQUENCE at 50 (as seen above). I set the SEQUENCE...
December 12, 2012 at 10:37 am
There are no triggers on the table.
The table has records periodically imported into it, every 5 minutes. Records were created as follows:
integrationQueueID, Created
7002 - 7018, 11:20am
7019 -7023, ...
December 12, 2012 at 10:36 am
I continued to have this problem, the SEQUENCE somehow "resetting" to a lower value.
I was caching the SEQUENCE at 50 (as seen above). I set the SEQUENCE to NOCACHE...
December 10, 2012 at 2:15 pm
Hi Lowell,
No triggers on the table.
The table has records periodically imported into it, every 5 minutes. Records were created as follows:
integrationQueueID, Created
7002 - 7018, 11:20am
7019 -7023, 11:25am
7024 -...
December 5, 2012 at 3:03 pm
CELKO,
I'm learning a lot though this process, thinking much more carefully about how I should organize my CIs.
Dave
November 22, 2012 at 10:57 am
Hi Jeff. That's my whole question really. Is there a good way to fix this and is it worth trying to fix.
True using a UDF to generate the UUIDs will...
November 22, 2012 at 10:53 am
Jeff, there are zillions of lines of app code that have queries joining on and referencing the UUID.
November 21, 2012 at 6:46 pm
Hi Tom.
It's counter intuitive, but that is how SQL orders UniqueIdentifiers.
November 21, 2012 at 6:44 pm
Thanks for your help opc.three.
One last thing: I hate to leave less than optimal code out there for posterity so here is my last, optimized function with all string...
November 21, 2012 at 11:40 am
Viewing 15 posts - 16 through 30 (of 34 total)