mtillman-921105 (12/28/2011)

---

Good find Gus, I must have used the wrong search words or search engine - or both!

In a way though, that sort of begs the question: I wonder how...

mtillman-921105 (12/28/2011)

---

Then that makes sense for Virginia.

But I'd like to know more about Colorado - especially since I'm lucky enough to live here now. 🙂

Steve, maybe you could let...

GilaMonster (12/28/2011)

---

At around $1000 for a single license.

They have one for SQL...

mtillman-921105 (12/28/2011)

---

There are a lot of terrific people in SQL who I don't know. So I'm sure the winners were great.

Anyway, I was surprised by this map. Guess...

David Moutray (12/28/2011)

---

GSquared (12/28/2011)No, I agree with you. In a database that's loaded purely by a scheduled ETL process (or more than one), there's no reason to worry about...

Michael Valentine Jones (12/28/2011)

---

I don't see how RCS would be a problem in a data warehouse\datamart application.

If there are no inserts/updates/deletes happening, then there are no row versions being generated...

David Moutray (12/28/2011)

---

Well, as I research the issue further, I am beginning to agree with all of you. RCSI is not going to help, and it just might make...

No,...

MyDoggieJessie (12/28/2011)

---

We have a lot of that same logic (using updlock/rowlock) riddled throughout our 3rd party code (coreCARD) and it's there because of the way the transactions are being processed....

I'll assume you haven't got any sort of data auditing turned on, otherwise you wouldn't need to ask about it. That's the best way, but that's hindsight for you...

Attention to details in building and administering software systems is amazingly complex.

For example, how many DBAs might run a trace on a production database, and not realize they might be...

Both of those solutions will work on very small datasets. If your database will ever have a larger number of rows, either of those will choke performance-wise.

Only use them...

Dev (12/28/2011)

---

GSquared (12/28/2011)

---

If I'm reading it correctly, it's pretty much just a "Where in (values)" statement with as close to unlimited number of allowed values as they felt...

Oh?

I've...

I can't say I'd use RCS on a warehouse under any circumstance I can think of.

Normally, a warehouse has a load interval, and TablockX is usually more appropriate during that...