Budget talks are coming up and I'd like to throw PASS into the mix for next year (the wost that can happen is they say no). What is reasonable...

One item that you may run into since I had something similar happen recently - turning the enforce password policy off didn't undo the "must change password at next logon"...

BWA HAHAHAHAHAHAHAHA! :w00t:

That was awesome.

I'll just put a link to this thread in the answer explination.

Whew....

Fortunately, they can't do the *= outer joins in the where clause in 2K5 or later unless they set the compatibility level back to 80. Those always seemed to...

I've submitted a couple QOD and they went well - no real big complainers, but I've seen others make pretty simple easy mistakes (the kind I could easily see myself...

Nice! Would not have expected this. Thanks for the question.

Chad

Where appropriate, disabling indexes can help boost delete speeds as well. I frequently create a "pared-down" database with a small subset of records. Since no one is querying...

I'm going to guess that this happens because sp_rename has a RETURN 1 right after the RAISERROR to break out of the procedure and the RETURN succeeds, resetting the value...

Good question. I don't know how many queries I've rewritten just because the original author didn't know how to use a group by. It's always nice to reduce...

I think this question is valuable beyond just the trivia for several reasons:

1. Be careful when searching for brackets using like - they are a special character just like...

I picked this option and it's the only reason I was wrong, be nice to know why that particular option is incorrect (I'm assuming it's the stats, but can't confirm...

For me, I found How to Win Friends and Influence People by Dale Carnegie and Getting To Yes by Bruce Patton to be invaluable. They taught me more than...

I believe SSC changed the code tags awhile back - I wonder if it happens to be that the question was submitted before the change and published afterwards.

jcrawf02 (8/11/2009)

---

Your galactic public relations department has decided to unveil the child in all of us, the new icon for the warm and fuzzy Dark Side, Darth Spitupicus. Your appreciation...

Gianluca Sartori (8/11/2009)

---

Some time ago there was a thread entitled "Should you use your real name as nickname?".

Maybe it's time to start the "Should you use your real pic as...