Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ancheril
Starting Member
2 Posts |
 Posted - 2009-07-16 : 06:35:43
|
| I am facing some issue with sequential GUIDs. I could not find a solution for that.newSequentailid() function I used for a table as default value for the primary key.I worked fine for two weeks till June 10th. There are about 1 lakh records inserted per day to the table. The sequiantail guid inserted on June 10th is the largest ID now in the table. All the ids inserted after that are smaller than that.This topic is under discussion in http://forum.ancheril.netShobin Mathewwww.ancheril.netBLog: http://blog.ancheril.netForum: http://forum.ancheril.net |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-07-16 : 06:43:52
|
Largest, according to what?The GUID is a binary value, which is interpreted and displayed as a string.Do a conversion back to binary and see if the records are stored in the correct order.
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
ancheril
Starting Member
2 Posts |
|
|
|
|
|
newsequentilid() function issue