Interesting. I haven't studied the plan cache in detail, so I guessed the answer.

There's a typo and a math error in the paragraph about query size:

There is a limit on...

paul.knibbs (12/10/2015)

---

So "NonQuery" implies you never asked the question in the first place, which is exactly the point I was...

Well, a query is...

Hugo Kornelis (11/24/2015)

---

The correct answer is missing: "The table doesn't have a primary key". It's also suspect that all columns are nullable.

From the answer options I deduced that I needed...

How would you propose to do that,...

Great article

Powershell fans: write this same type of article using powershell instead and publish it here. Then readers will have easy reference to two great ways to accomplish this.

I disagree with this point. I find that consistent use of brackets makes it...

Luis Cazares (11/6/2015)

---

sknox (11/6/2015)

---

Luis Cazares (11/6/2015)

---

2...

Luis Cazares (11/6/2015)

---

2 letter abbreviations are...

Patrick Cahill (10/29/2015)

---

Good question, but I disagree with the explanation to create the view with SCHEMABINDING. This can lead to other issues if the table gets very large. I'm not...

should be

The maximum number of subdirectory...

billp 37934 (10/5/2015)

---

not enough code review and coaching?

It's amazing how easy it is to make a living as a programmer for years writing the stupidest code. It's...

if 1 = 0

...

This question is almost more about TRUNCATE than IDENTITY. All of the inserts before the TRUNCATE are just red herrings. But made me think of the following SQL forum joke:

TRUNCATE...

SQLRNNR (10/2/2015)

---

Stewart "Arturius" Campbell (10/2/2015)

---

Interesting question, given that, according to msdn & technet, federated Azure have been retired:

Federations will be retired with Web and Business service tiers in September 2015....