James Goodwin (12/11/2007)

---

I guess that doesn't really...

If you don't care about actual tracking, you can still use a "blocking table" with a unique index on it (i.e. something allowing only one record in the particular table).

First...

I think you just need to change the LEFT JOIN to be an INNER JOIN?

Depending on the syntax - an oleDB provider can execute the query client-side (or locally). That means you might be pulling a LOT of data only to have it...

My version of Suse had BOTH CD's in the package. Try the other disk?

I was a bit disappointed by it as well after the testing. The syntax is cleaner, but it's limiting (only on specific type of operation per PIVOT statement for...

Will Summers (12/11/2007)

---

Maybe I'm just asking what is the advantage of a PK over just a simple unique index? Is there any potential increase in speed? Cause if...

Steve Jones - Editor (12/7/2007)

---

No one wants their boss to do something?

Peter, no first class travel? Extra night on the road?

Will, no dedicated time to experiment with mouse speeds/sensitivity?

Matt,...

Start shipping your ice, snow, sleet to the southeast. Black Ice, clear or otherwise. Really - we'll take it.

If I understand correctly - you only want repromotes when they return to their previous highest level.

This ought to do it:

--run this once

alter table volume

ADD PrevMaxLev int

create index ix_volume...

I'm pretty sure that code catches multiple occurrences, but just so I'm sure - could you mock up some data as you'd expect it to look after such an update?...

TheSQLGuru (12/10/2007)

---

My comment was directed at an optimally sized/configured SAN. I don't consider a SAN with 512 LUNs to be optimally configured for database throughput. DAS with that...

I'm sure we could collapse this into a single statement, but...

Careful about the "reset" at the beginning, in case you're using the repflag for anything else.

update volume set repflag=''

update a

set...

If you want a specific order - you should specify an ORDER BY clause. Because of the way SQL server accesses data, you can't count on it using a...

Happy to help!