rragno (9/23/2012)

---

Unlike the C# code, this always takes 0 ms to execute. It appears to simply analyze the code and conclude that only the last iteration of the loop will...

SQL Kiwi (9/23/2012)

---

L' Eomot Inversé (9/23/2012)

---

It would be interesting to see the C# so that we could see what it is that's being optimised. Clearly either the C# optimiser...

And here's him correcting me on something that I have been wrong...

CELKO (9/22/2012)

---

Yes, you can. In the...

GSquared (8/1/2012)

---

Post-script: Name-case coding will be wrong much of the time. Bill O'Malley will likely end up as Bill O'malley, or Bob's will end up as Bob'S, unless you...

rragno (8/1/2012)

---

It is irritating how big the gap is between the performance here and high-performance code, though. Why should we have to be impressed that multiplying a million numbers takes...

Great article. I will have to remember the content, because it could make a big difference in many things.

But you worried me a little in one of your comments,...

No, they will be different.

Your structure (with both the data and the index) is a tree of pages. The data pages are just the leaf pages in that tree....

Risks being read as a license to be lazy about...

CELKO (9/22/2012)

---

This is a very different kind of programming. I think that 80-95% of the work is in the DDL (CREATE TABLE, etc), not in the DML (queries, etc). If...

Sean Lange (9/22/2012)

---

F8R (9/22/2012)

---

Ok, I'm hijacking my own thread, 😀

At this design, Orders only accept registered Customer, but I want Non Registered Customer can place Order, so I add CustomerType...

SQLRNNR (9/21/2012)

---

Personally, I am glad that Joe took the high road on that thread. Joe does get pedantic a lot - he knows it and said it. Typically...

SQL Kiwi (9/21/2012)

---

Brandie Tarvin (9/21/2012)

---

I can't blame him for being defensive. Eugene basically invited Celko into that thread for the sole purpose of roasting him. There really was no excuse...

hkamal.infoedge (9/21/2012)

---

I think Answer should be "None of the Above" Or we need to change the question

As DiskIO in sp_Who2 means reads and writes combined, not just reads as question...

Nice tidy question. Thanks.