PHYData DBA (8/27/2013)

---

Nice easy question... I always wondered why you can have a Primary Key on a heap and its still a heap if there is no clustered index on...

While I wouldn't go quite as far as Jason and say the question is incorrect, and I do with Hugo that the explanation is misleading and awful, but that the...

You have something close to the core of it there, because something like the subquery in the EXISTS expression is a good starting point. But it's going to print...

Steve Jones - SSC Editor (8/26/2013)

---

33 slides is...

GilaMonster (8/26/2013)

---

So the current list is:

No need to index small tables

No need to index tables that fit into memory

Indexes enforce physical order of data

Seeks are better than scans

Clustered index seek/scan...

Thomas Abraham (8/26/2013)

---

Jeff.MSSqlSage (8/26/2013)

---

Thomas Abraham (8/26/2013)

---

Thanks for the Monday question. I was happy to begin the week with a question that didn't start with "When can normalising ...". 🙂

As for...

If the status really is just an attribute of the main item rather than a separate entity that is related to it, the restriction on the set of values is...

Hugo Kornelis (8/26/2013)

---

Hi Tom,

I just wasted two hours typing a long reply to your message, then forgetting to do a copy/paste before posting. I really hate this site at times...

But is that just what currently...

Good question, and really terrific reference. That page should debunk many widely believed myths and isn't propagating any, which is quite unusual for a page that talks about the...

I imagine that calling that multi-line UDF for each update/insert operation on the table will be a pretty horrifying overhead, but it's easy enough to rewrite it as a...

Yes, we should try to get our offices, server rooms, and so on up to a high standard of physical security.

But something far more important for us to...

Jan Arnoldus (8/24/2013)

---

Hi Jeff,

We did this test to check the overall response time on high number of consecutively updates, which is similar to the pattern the table is used...

If you like using aggregates (all those MINs suggest that) and are not too concerned by the idea of using two queries instead of one, and that "having the most...

Presumably you are using IN rather than = because you want all the documents that satisfy the condition in the cases where there are more than one. But CASE...