The great thing about Michelle's script is the history. With further analysis I could spot ± 100 indexes that needed to be moved to 80 fill factor instead of...

Works for me now...

Lowell (5/9/2011)

yep i created...

I use her script and it works perfectly.

Rebuild the index will update those stats.

I personnally just run this daily (large maint. window too and it takes 15 minutes to run...

CASE

WHEN axxia01.dbo.nmnomtrn.nt_addesc = 'N'

THEN axxia01.dbo.nmnomtrn.nt_trdesc,

Remove the comma at the end of that last line

"cast(curamount/ISNULL(NULLIF(sum(curamount), 0), 1) over (partition by employeeid,docdate) as decimal (10,4)) as Total"

Awesome, post that execution plan too plz.

Please post the plan (actual plan, not estimated).

Are the index defragmented and the stats up to date?

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/

Thanks Gail, I had successfully forgotten the 3 other threads he started...

I forgot who said that to his boss / client but it went something like this.

We don't want any downtimes.

Sure, how many Millions do you have budgeted for this solution?

Errm,...

It's already 3:30 PM here. Was about time I...

Alright... let's just call it friday afternoon and time to go home.

l8r! ;-):-P:-D:hehe::smooooth:

ya but you beat me to it :w00t:

So somehow it must be your fault :hehe:

Those are called jobs.

Check it out in books online.

DECLARE @openorder INT

SET @openorder = 2

DECLARE @tbl TABLE (openorder INT)

INSERT INTO @tbl (openorder)

SELECT 0

UNION ALL

SELECT 1

UNION ALL

SELECT 2

UNION ALL

SELECT 3

UNION ALL

SELECT 4

--UNION ALL

SELECT

*

FROM

...