Lynn Pettis (7/13/2015)

---

OMG! How does Silver Spoon keep his job? Member of ssc for over 10 years and can't seem to do the simplest tasks without running to the...

Yes, quite so. 😎

Doing it with...

Steve Jones - SSC Editor (7/13/2015)

---

I tend to agree with Jeff, and others, but XML isn't a bad or good thing. Storing data in XML is great for interchange, and...

GilaMonster (7/13/2015)

---

M.Sc...

Jeff Moden (7/13/2015)

---

The correct answer isn't actually available. The correct answer should be to "hunt down the moroff that used XML to transmit purely flat data and introduce him...

emmchild (7/12/2015)

---

Competing requires a generalist with the ability to specialize when necessary. The fear off job loss stems from the lack of general skills and the unwillingness to acquire...

I had to do a lot of testing of data comms software many years ago, and we always arranged to have switchable relay somewhere in the link to test timeouts...

mtlsql (7/12/2015)

---

So there's no other way to drop it before that?

Why are you using a table variable...

I don't like having to look up identity numbers to insert into tables, so rather than inserting literals into the UserCategories table I would use something like

INSERT INTO dbo.UserCategories

...

It shouldn't be if you used Ed's primary key definitions.

Did you remember...

Eirikur Eiriksson (7/10/2015)

---

Spot on Jeff but it doesn't take Chinese though, everyone has heard stories of strange things ordered in French restaurants etc.. Guess the French also use automatic translation...

In addition to what Ed says, you may need to enforce uniqueness on the user-category pair; also (for performance) you may want to have a index on whichever of the...

Good question. I got it wrong, so learnt something.

I wonder why it isn't documented in the Max Capacity specs page for CTP2.

Alvin Ramard (7/8/2015)

---

LSAdvantage (7/8/2015)

---

Am I the only dummy that doesn't look stuff up before answering? I have been going about this all wrong trying to "test" myself! :-D...

RK Mandava (7/9/2015)

---

david.gugg (7/9/2015)

---

What is the difference between Shared Storage and SMB File Share? The link on that msdn page goes to https://msdn.microsoft.com/en-us/library/ms143506(v=sql.110).aspx#storagetypes, but it doesn't really describe them,...