Yes. There are super-secret forums that only people with 0 posts are allowed to see. The rest of us have to make do with whatever else is available.

You...

There are bits of the SQL Prompt engine that get me too. ID is one of them, as is the XQuery "value" function. It's case-sensitive, has to be...

I've done pretty heavy testing on this. The DateAdd-DateDiff method has been the fastest, and has the advantage of being both backwards and forwards compatible.

The Int conversion has rounding...

Oh, one other advantage of CLR vs xp_CmdShell:

Nobody is likely to ever going to be impressed by, "Really good at xp_CmdShell" on a resume. "Grand Master at command line...

Ah. That's what I get for not reading the newsletter till after work. 🙂

The big question on tempdb usage in snapshot isolation isn't the total size of the database, it's the frequency and magnititude of page writing.

Rows have to be versioned in tempdb...

Any particular reason to resurrect a discussion that's 3 years old? Or just bored?

rob.carter 79958 (6/14/2011)

---

Surely too few or too many parentheses should be in the list somewhere, or parentheses in the worong place bracketing off an innappropriate criteria.

And I agree that SQL...

David Hutcheson (6/14/2011)

---

"SSMS does - just occasionally - report an error where none exists."

Really? This is the fifth most common SQL Server error? After using SQL Server pretty much every...

Craig Farrell (6/13/2011)

---

I'm afraid I would disagree with Carlos above, however, my approach is very different for ultra-wides.

For the primary table, make sure it has your business keys and your...

Steve Jones - SSC Editor (6/13/2011)

---

My daughter was not thrilled with FL last weekend. Too hot for her. My wife canceled a trip to Baton Rouge with me for the...

Jeff Moden (6/13/2011)

---

That's interesting. Thanks, Gus. You mention more effective mitigation...

calvo (6/13/2011)

---

When was the last time you played WoW? All classes now have a...

Jack Corbett (6/13/2011)

---

Haven't been on here in awhile, and haven't even tried to catch up yet. I've been packing and cleaning the last 2 weeks and tomorrow is the...

Honestly, I recommend against using it these days. CLR procedures can do anything it can do, more securely. So, in an SQL 2000 environment, I can see using...