Jeff, with RCSI enabled, it’s barely if ever necessary.

Ignore the obvious comments from people who don’t understand the needs of say a live, production reporting system where 1000 units a minute can be produced

1,000 units a minute is...

This article contains several inaccuracies and incorrect assumptions about what it means to read uncommitted data (which is what NOLOCK offers). I strongly advise against following the instructions in this...

FWIW, Argenis owns datasaturday.com. It's not like we couldn't come to an agreement with him if we asked nicely.

See, this is why I started off by suggesting Data Saturdays is the top of the hierarchy and SQLSaturday falls under it (which was one of Steve's ideas).

“SQL” pronounced “Sequel” rolls off the tongue because we’re used to it. In the outside world, a lot of people spell out the letters or pronounce it differently. We are...

In-person events are an incredibly bad idea anywhere that isn’t New Zealand.

Legality is not the issue: caring about the lives of other human beings is.

Have some compassion. One of my...

Thanks for your comment, Chris. My word of the year for 2019 was “nuance”, and this is a great example of where NOT being quick to judge is the safer...

The one I've mentioned before, which I don't work on anymore but still exists, is the SQL Server 2000 database running in 6.5 compatibility mode, with a Visual C++ 6.0...

You will probably see some sort of improvement, but the degree of improvement depends on many factors specific to your environment.

That said, I've had performance improve quite dramatically after defragging...

Not bad. I liked the bit where you lapsed into Latin 🙂

UTC gets my vote as well. It's simpler to compare times at the database level if necessary, and of course the comments about moving servers, DST apply too.

From a US perspective, I think SQL Server is very well priced. I think that what comes in the box is a great deal, and is very useful too. My...

GilaMonster (1/15/2010)

---

Randolph Potter (1/15/2010)

---

One thing I've been begging Microsoft for, is country-specific pricing. I'm pretty sure this is difficult to manage to avoid abuse, but it would make it more...

One thing I've been begging Microsoft for, is country-specific pricing. I'm pretty sure this is difficult to manage to avoid abuse, but it would make it more affordable, especially with...