I didn't know Chipotles were real places. I'd only seen them on that South Park episode. Really good question though!

If you didn't know anything about replication you'd say that the first option was pretty much the same as the last one so you'd select option 2.

If you did know...

Seems quite widespread. I have people whom I...

Same here :doze:

Yes, I fell down on the Filestream one because of that!

Perhaps it wasn't as easy as some of the resident "experts" claim. It's anything but logical behaviour and you can...

If you did want to do it (and I agree that the normalised solution is better) you'd need to go with a Global Temp table rather than just a normal...

Excellent point - if using NVARCHAR the query also returns the row corresponding...

Well, I ran the code and it started raining (in London).

I feel I should throw my toys out of the pram and demand "my" point back as is the...

Well, like 50% of respondents I got it wrong (wasn't too sure on the .ndf option). Nice to learn that it was a really simple question though :Whistling:

I Googled it too 🙂

Perhaps it was a trial edition which had expired.

Also known as "Deep Tables". I'll start calling them EAVs now to confuse my boss.

I use the windowing functions a lot and still agonise over some of the code I wrote before I knew they existed.

Here's my effort which is in tribute to (not...

Thanks, David - that was indeed what I was suggesting.

Without knowing more about the business it's hard to be more specific. I have implemented Project Tracking solutions in the past...