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 |
|
homertechnologies
Starting Member
12 Posts |
 Posted - 2014-06-26 : 13:22:09
|
| One of our application has only 5000 records, but because of this jump issue the maximum id value of the recent record is 125634. The ID value is shown to the client, looks weird to them and us. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-06-26 : 13:26:54
|
| If the gap is due to this, then use trace flag 272. Microsoft has said it's not a bug and didn't fix it even in SQL Server 2014. If the gap is due to rollbacks or deletes, then you need to figure out what's more important: performance/scalability or the gaps.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
homertechnologies
Starting Member
12 Posts |
Posted - 2014-06-26 : 13:44:55
|
| can't do trace flag in shared hosting server. just living with it |
|
|
|
|
|
|
SQL Server 2012 Auto Identity Column Jump Issue