The main idea of keeping everything in sequence is ofcourse always a performance issue as changing one record implicitly means an update to all following records, which is implicitly expensive...

mmarovic (2/2/2011)

---

Hello Jeff & Co. Really great article and awesome discussion. I wrote an article about the topic five years ago, but my investigation lacked depth of the Jeff's article...

Jeff Moden (1/25/2011)

---

WayneS (1/24/2011)

---

Yet another article where the discussion is as valuable as the article itself! 🙂

Well done Jeff on (yet another) great article. And well done to all that...

I DISCOVERED AN ERROR IN MY CODE HERE, SKEWING THE RESULTS, PLEASE IGNORE THIS PART OF MY CONTRIBUTION

(In one of the two datediffs, I used getDate() instead of "SomeDate" that...

I did some more testing and as it turns out, much of the cost in slower solutions is in dissecting a date multiple times and/or using an inefficient method. And...

Thanks again Jeff for the discussions you always seem to bring up among us.

Time to put in a few thoughts and findings of my own. As someone already observed, DATENAME...

I think RAID 5 must be burried.

It was once introduced when magnetic disks where still very expensive and capacity limited, while at the same time there was a need for...

To make matters worse:

This means that if we have an expression in the select...

The article states the following:

First off, you need SQL Server Enterprise Edition or Developer Edition. None of the other editions of SQL Server 2005 or 2008 support partitioning. SQL Server...

Don't forget to first use: DBCC UPDATEUSAGE(0);

BOL says about this:

Reports and corrects pages and row count inaccuracies in the catalog views. These inaccuracies may cause incorrect space usage reports returned...

SwePeso (12/6/2010)

---

It seems the dual TOP/ORDER BY was the most efficient approach by the time.

I tested the new Denali OFFSET/FETCH and I got the exact same number of reads for...

I can agree with your point of view where it concerns your own database usage, which I cannot see as typical of relational databases in general. Rebulding all data every...

vmssanthosh (11/15/2010)

---

hi

I have a debate over this concept.

Foreign key and check constraints are referential integrity components. How we can say this will increase the query performance.

Yes it may increase...

pslavik (10/21/2010)

---

This is interesting and it certainly makes sense. But this has only shown improvements in select statements. How about insert/update statements. I would imagine that foreign keys will actually...

These days it is made easy to produce "something" really quick and thus cost efficient at first glance. The problem is that without common sense and care for details, what...