Dan,

That sounds like something that I'd be looking hard at. If you could repro, that would be interesting.

CirquedeSQLeil (11/25/2009)

Jack Corbett (11/25/2009)

Okay, Steve will be gone, now we can...

Stuffing myself with pizza after skiing. Likely gone until Monday, so everyone enjoy (and behave) themselves.

Dan,

The likely candidate is someone inserting a value using SET IDENTITY_INSERT ON that is too high.

A rollback should not have affected things, as you've noted. If you inserted 1,000...

http://msdn.microsoft.com/en-us/library/ms177648%28SQL.90%29.aspx

Jason is correct. You'd want to completely regression test your app against the server. This is one reason I wouldn't recommend CUs unless you are hit with a fix in...

That is strange. The truncates should only take a second or two to drop the extents. The BULK INSERTS should let go of the tables and run normally. Can you...

I use MB, but I also have regular monitoring that can help me avoid needing autogrow except in emergencies. Be sure if autogrow does occur, you have some sort of...

It can be hard, not to mention not necessarily acceptable in an environment, to change all procs. Someone will add a line of code, not realizing that there's been another...

You can't force someone to sit on a page for 2 minutes. None of us would do it, and we would never come back. You can't force people to read...

You have to escape the quote, so double it up.

Meaning that a single quote needs 2. If it is adjacent to an opening or closing quote, you'll have 3

select '''test'''

The...

Hey, I used to count binary on my fingers in comp sci. Back in the 8 bit days when we needed to bit mask to fit things in. Always started...

At this point I am completely lost on where THE THREAD is, though I didn't see a #6 movie or a #7 book.

Jeff,

Nice post, and a great way to handle the phone numbers. I wasn't aware of NPA/NXX, and that's good to know.

I would agree with you that storing these values in...

Well, I'm hoping you don't work for my bank, doctor, mortgage broker, etc.

I've seen similar things in many places. I have had to implement the "change sysadmin password immediately when...