What will the max id be?

Question

Post reply

What will the max id be?

bkubicek

SSChampion

Points: 10948
More actions
December 18, 2012 at 8:51 pm

#271717

Comments posted to this topic are about the item What will the max id be?
December 19, 2012 at 3:56 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 35 total)

You must be logged in to reply to this topic. Login to reply

Ron McCullough SSC Guru Points: 63877 More actions · Answer 1

Nice back to basics question - thanks

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

SQLRNNR SSC Guru Points: 281334 More actions · Answer 2

EZPZ

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Lokesh Vij SSChampion Points: 10836 More actions · Answer 3

Thanks for reminding the basics 🙂

~ Lokesh Vij

Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com[/url]

Follow me @Twitter

kapil_kk SSC-Insane Points: 21316 More actions · Answer 4

easy one for Wednesday 🙂

revision of basics........

_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

demonfox SSCertifiable Points: 6289 More actions · Answer 5

easy ...truncate resets the identity;

It's a coincidence , I was just discussing it with my colleague about inserting a row in between identity inserted column. And yes, Truncate popped up as an option 🙂

~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 6

Easy one, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Paul White SSC Guru Points: 150467 More actions · Answer 7

Another good one. 19% wrong right now :blink:

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

palotaiarpad SSCertifiable Points: 5617 More actions · Answer 8

I'm also wrong, but i learned something. Could someone please explain, why is the identity resetted after a truncate? For me is a possible source of inconsitency.

Igor Micev SSC-Dedicated Points: 33109 More actions · Answer 9

Nice question.

Thanks

Igor Micev,My blog: www.igormicev.com

Lokesh Vij SSChampion Points: 10836 More actions · Answer 10

palotaiarpad (12/19/2012)
I'm also wrong, but i learned something. Could someone please explain, why is the identity resetted after a truncate? For me is a possible source of inconsitency.

TRUNCATE command apart from removing data from the table, resets the seed value of the identity column defined in the table.

Another command to re-seed identity is DBCC CHECKIDENT. It can be used something like below:

DBCC CHECKIDENT ('test_trun', RESEED, 0)

~ Lokesh Vij

Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com[/url]

Follow me @Twitter

Lokesh Vij SSChampion Points: 10836 More actions · Answer 11

palotaiarpad (12/19/2012)
For me is a possible source of inconsitency.

Not sure why you said this as "inconsistency"...it's just the property of TRUNCATE command!

~ Lokesh Vij

Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com[/url]

Follow me @Twitter

kapil_kk SSC-Insane Points: 21316 More actions · Answer 12

bcoz it is its behavior that every time we execute TRUNCATE command it will reset the identity value..

_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

(Bob Brown) SSCrazy Points: 2705 More actions · Answer 13

(Bob Brown)

SSCrazy

Points: 2705

December 19, 2012 at 4:34 am

#1569983

Thanks for a nice easy Wednesday question.