http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

Short story short. You have a FREE working solution from Brad which is an MVP (AFAIK).

It's been tested and put in production for months without issue.

If it works for...

What cost of SQL agent? It's free... once you paid for the sql server license!

As for hardware cost it's extremely limited.

I've seen backup exec work and I'll take my...

You're already talking to a few mvps here and some who could just be nominated if they started their own blog and posted once / week for a few months.

Nobody...

[not a lawer, barely above moron level, you should not listen to me, this is not advice, think for your own darn self... blah blah blah]

... which goes AROUND the...

Robert L. Jones-330863 (6/29/2011)

---

I do believe that Craig is right. In the file License_EXPR_ENU.txt from 2005 Express it states:

4. SCOPE OF LICENSE. The software is licensed, not...

Not really. It's just much less likely to grow (takes a massive single transaction to force autogrow, at which point it shouldn't shrink back down).

So...

Don't have time to tune this ATM. NOt a 2 sec job.

You have a miss. index warning, you could start with that.

Try to move the where a little sonner...

So you still need help of you're all set?

The formula should look something like this :

=SUM(Qty * Price) / Qty

Yes and by definition avg means you have ± 50% over and 50% under the avg. So I would define what over avg really means so you don't get...

That's why I said very rarely and not never :w00t:!.

I didn't feel like going down that rabit hole ATM... nor searching again for that link :w00t:.

More to the point I...

Virtualized?

Can't help. Looks like he's slipping back into his old habit of giving completely useless advice without really trying...