Thanks for a question I didn't have to question my gut instinct answer about.

Nice Article

Just one of many many reasons that going after the system tables should be done with much trepidation.

Hugo Kornelis (9/13/2012)

---

mtassin (9/13/2012)

---

that said... your idea of screwing with somebody by reconfiguring the SSMS client when they are AFK to make SELECT a batch separator... is an awesome idea....

Hugo Kornelis (9/13/2012)

---

Finally, I can give you one example where this knowledge can be useful: when you have a co-worker whose idea of fun it is to change the batch...

Nice Article.... wish I had read it last week when I was working on a project that needed a bunch of conditional processing... This was just the ticket on...

Hugo Kornelis (8/31/2012)

---

I voted as well - but I voted it down. I fail to see any realistic situation where I would need to be able to use IDENTITY_INSERT on...

Glad to be part of the 27% that got it right, but that's only because I had the 4 to go by.

I would have probably bypassed the columnstore one otherwise....

Ernie Schlangen (8/29/2012)

---

From http://msdn.microsoft.com/en-us/library/ms174979.aspx:

SPARSE

Indicates that the column is a sparse column. The storage of sparse columns is optimized for null values. Sparse columns cannot be designated as NOT...

Oops... didn't pay close attention and got Catalog Views and DMVs mixed up.

Good question... wish I had gotten it correct... heh...

Hugo Kornelis (8/23/2012)

---

Which proves exactly the point sknox was making: that you didn't read the error message carefully.

This time, you were lucky - by not reading all parts of the...

sknox (8/23/2012)

---

The question included a very specific error message as your only failure option, which was clearly not related to the (non)existence of a table. You happened to get it...

Steve Jones - SSC Editor (8/23/2012)

---

I'll disagree with you and agree with sknox.

If you thought that you could do an insert into @x without defining @x, you would learn something...

I disagree,

I...

Realized I skipped the xml function tricky thing.

First run 100 times

runtype durationms

delimitedsplit8k89

xml ...

I'm not seeing the XML trouncing the Delimittedsplit8k tvf though.

My test code I'm using DateTime2 for the greater accuracy

DECLARE @STR VARCHAR(8000)

DECLARE @ItemID VARCHAR(8000)

DECLARE @Item VARCHAR(8000)

SET