Who the %?(&?%$ figured that technic out and how much time did it take him????????????

Can I marry him/her

Better now?

Which version of NSP are you reffering to?

BTW that post is actually the 24th message of the thread.

I was referring to noeld's working solution for the openrowset.

Been there... The guy actually wanted 99.9% of the db on a single report... he got a sound no way .

What's the normal growth of the db?

1 gig month/week?

It's hard to tell what's going on without knowing what normal actually is. Can you get this info?

It can't be blocking itself (same spid for blocked and blocked by??) with only one thread.... I'd really try the maxdop option if I were you... especially since I have...

No we're not... just stating that there might be a better way.

BTW I was actually serious about the junior DBA position .

Next monthly report, add a 15 hours timespan title : file timesheet .

Why is the set fmtonly off required?

As far as I remember, the first .net add something like 70k methods/functions. You'll never learn 'em all .

I'm not sure I get the requirements... Can you post the expected results of the query with the presented data?

SP was in the context of stored proc .

Anyways try to add the hint option (Maxdop 1). Sometime the query can block...

Damn... do you need an assitant, maybe a junior DBA .

Looks like this one didn't catch on right away... might have been to direct too the point .