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...

There isn't necessarily an easy way to dot his. If you have a read only table, set it to 100. If you have one that heavily changes, you will likely...

Your first step is to read the UPGRADE section in Books online. That will give you the steps that occur, and what the documentation is. If you don't understand something,...

I haven't heard from Barry. Hope he's well. Haven't seen any blogs appearing either. I'll try to email him.

Ok, but if you update two columns, you CTE needs to have

where i.colA != d.colA

OR i.colB != d.colB

And so on for other columns. You have to think about listing...

I assume you're working on the real syntax here. A couple things

1. The INSERT should fail as I believe the CTE will be out of scope at the end of...