>>they're a last resort

No, forums are NOT the last resort! If you can't figure it out for yourself, don't have someone at work to assist, can't get someone to...

I don't think you need a 'moving aggregate'. You simply need to count emails per user for a period:

select userid, count(*)

from emaillog

where sendtime less than 60 minutes ago

group by...

For some reason I cannot view the plan, but you are joining 12 tables (hopefully none of those are views), so any aberation in the rowcount estimation by the optimizer...

Good stuff - too bad it won't actually be read by any of those who might need it. 🙁

Greg Roberts-134214 (5/12/2010)

---

2) I cannot change the structure of the production database. I have a nightly ETL that migrates the data from production to a reporting database.

1) I...

1) I would like for you to tell me exactly why you think you need/want partitioning, and also what you think you will gain by partitioning. Most people think...

I have done this evolution for numerous clients. I use sp_helpindex3 to generate the information on all indexes and then use my Mark I calibrated eyeballs and Excel to...

>> WHERE NOTETYPES.Associated_Department_ID IS NULL OR OPERDEPTMBR.Operator_ID = @Operator_ID

That type of WHERE clause is HORRIBLE from a performance standpoint. Our own Gail Shaw has a very nice blog post...

My statement above applies to TVFs also, at least ones that aren't inlined by the optimizer.

I will add that as a consultant in the past 3-4 years I have probably...

The best plan choices would likely be made (over many iterations with many different values in the delimited string) by putting the values into a temporary table first and then...

Give a qualified professional a few hours access to your system for a performance review. I think you would be surprised what would be found - and you could...

Or you can simply use ApexSQL Edit, which has some very spiffy built-in source code control functionalilty - among many other features.

Disclaimer: I have a close relationship with Apex,...

Hell, I just installed my first copy of SQL 2008 (NOT R2) on my laptop just two months ago!! I have never had a version of 2008 R2 on...

Paul White NZ (5/5/2010)

---

Yes to the loop join - but that's exactly what is...

Solomon Rutzky (5/5/2010)

---

aeternam (5/5/2010)

---

Using a while loop in combination with a table variable shouldn't, in general, be the best performing option.

How would this query perform:

SELECT <something>

FROM <the partitioned table>

WHERE etp.PartitionID...