LOL!!

I simply cannot believe the amount of discussion over what can of course only be a simple mistake by the question author.

The very definition of "correlated" is that the inner...

ChrisM@Work (7/22/2014)

---

Hugo Kornelis (7/21/2014)Especially for tuning, tempdb is not a good place to try. Various features of the optimzed are not used in tempdb! (I know because I have been...

Creating permanent tables in tempdb this way is tricky. They will behave "sort of" like permanent tables (they will not be removed when the batch ends or when you leave...

Got it wrong.

I hate these questions where a declaration bad practice is buried under a heap of distracting code. I know that this happens in real code too, but when...

Good question!

I am very happy to see someone pointing out this in my opinion dangerous and misguided default.

I just would like to add that there is a very big performance...

Andy Warren (6/20/2014)

---

Thanks all for trying the question. I'll work on my wording (I always try to!) more. It's crazy hard to get it done in a way that is...

rja.carnegie (6/26/2014)

---

I think I understand correctly that in fact all the indexes have a unique key in their internal structure. If they aren't declared as unique, the location of...

First, a comment about the "official" topic of the article.

I do agree, to some extent - but with a twist. I think that all indexes, both unique and nonunique, should...

The exact wording in Books Online is: "In this...

RLilj33 (6/6/2014)

---

I believe the process is: Entire database goes offline, Primary filegroup is restored, Primary filegroup comes back online, Subsequent filegroups can be brought online one at a time.

I have...

Uwe Ricken (5/25/2014)

---

Hi Steve,

curious. I've selected "no FK" as one and only option but it gave me "failed" 🙂

However - local temptable are valid in the sessein and they can...

I was surprised to see so many people claim that this is an easy question, since there is a very glaring error - there is only one error.

But after reading...

So you finally discovered the existence of my evil twin? (Hugo2)

I decided to run a quick experiment to see if I could find any limits. Here is the code I used to create a table with lots of foreign keys:

USE...

Jedak (5/20/2014)

---

We currently have a poorly designed audit system that requires 391 foreign keys to a single table. The interesting thing is once you get too many foreign keys...