What will the max id be?

Click here to monitor SSC

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>

SQLServerCentral is supported by Red Gate Software Ltd.

Log in :: Register :: Not logged in

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>

Recent Posts

Popular Topics

Home

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Ben Kubicek » What will the max id be?

Add to briefcase

36 posts, Page 1 of 4

What will the max id be?

Expand / Collapse

Author

Message

Posted Tuesday, December 18, 2012 8:51 PM

UDP Broadcaster

Group: General Forum Members
Last Login: Friday, February 01, 2013 8:13 AM
Points: 1,490, Visits: 388

Comments posted to this topic are about the item What will the max id be?

Post #1398128

bitbucket-25253

Posted Tuesday, December 18, 2012 8:52 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 6:46 AM
Points: 5,102, Visits: 20,207

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
Before posting a performance problem please read

Post #1398129

Posted Tuesday, December 18, 2012 9:24 PM

SSCoach

Group: General Forum Members
Last Login: Monday, May 20, 2013 1:07 PM
Points: 18,733, Visits: 12,332

EZPZ

Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp

Post #1398135

Posted Tuesday, December 18, 2012 10:17 PM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 8:24 AM
Points: 1,176, Visits: 1,253

Thanks for reminding the basics Smile

Smile

~ Lokesh Vij

Guidelines for quicker answers on T-SQL question
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com

Follow me @Twitter

Post #1398162

Posted Tuesday, December 18, 2012 11:00 PM

Ten Centuries

Group: General Forum Members
Last Login: Sunday, May 19, 2013 11:16 PM
Points: 1,061, Visits: 1,151

easy one for Wednesday Smile

Smile

revision of basics........

Post #1398172

Posted Tuesday, December 18, 2012 11:20 PM

Ten Centuries

Group: General Forum Members
Last Login: Saturday, May 18, 2013 6:46 PM
Points: 1,074, Visits: 1,076

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

Ermm

Post #1398193

Posted Tuesday, December 18, 2012 11:56 PM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 6:39 AM
Points: 9,376, Visits: 6,472

Easy one, thanks.

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence

Post #1398203

Posted Wednesday, December 19, 2012 12:11 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 5:10 PM
Points: 10,989, Visits: 10,535

Another good one. 19% wrong right now Blink

Blink

Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi

Post #1398208

Posted Wednesday, December 19, 2012 2:34 AM

SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 7:14 AM
Points: 848, Visits: 322

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.

Post #1398249

Posted Wednesday, December 19, 2012 2:46 AM

SSCommitted

Group: General Forum Members
Last Login: Today @ 6:17 AM
Points: 1,879, Visits: 1,452

Nice question.
Thanks

Post #1398253

« Prev Topic | Next Topic »

Add to briefcase

36 posts, Page 1 of 4

Permissions

Expand / Collapse