You haven't really given us nearly enough information to advise you.

You'll probably get some blocking with clustering + PAGLOCK because the jobs are still bound to share a page or tow, but the chance of deadlocking should be vastly reduced....

I checked it only because you said that you hadn't yet. Sorry, just trying to be helpful. 🙂

GilaMonster (6/15/2009)...No one I've spoken with knows exactly where the estimate is coming from. It's not the 30% of the table that's used with inequalities when a estimate can't be...

OK, as to your specific design question here is how I would do it:

A) Add a table like this:

CREATE TABLE PreProcessingLog

(

CustomerIDint,

CompletionTypeint,

--Types are 1=UserRequest, 2=DocType1, 4=DocType2, 8=DocType3

Primary Key Clustered (CustomerID,...

That's Klaus's book, right? That's the best book by far, however two words of warning:

1) If you haven't actually setup your first working demo or app yet (even...

A trace can definitely capture it, though I am not sure if the default trace captures this information, "by default".

Nuts (6/14/2009)

---

The code works fine in the Management studio.

But when I use the same code in the reporting services, it gives the error for the 'CTE'.

The error says 'CTE is...

Ahh, ahh. Don't feed the Tee Ar Oh El El.

Grant Fritchey (6/14/2009)

---

Jeff Moden (6/14/2009)

---

"Regular Sessions"? Are you talking about "general" sessions? I've not received anything...

OK, if I understand this, then this is the kind of flow that you are looking for:

...

Where will these three files reside while they are waiting to be processed?

Ooh, we're doing definitions? Hows this:

"A troll is someone who posts controversial, inflammatory, irrelevant or off-topic messages in an online community, such as an online discussion forum or chat...

Nice.

But I was actually thinking of "Snarky Malarky".

I still can't help thinking that doing the trigger logic as part of (or before) the Insert, partitioning the table and having a clustered index that keeps the Product ID's...