Kinda figured, but was hoping for something.

Thanks Steve.

Without the TF 1117 the splitting of the tempdb into multiple files is likely to be an utterly useless exercise as the load will more or less end up in...

this is pretty much what I was thinking of doing...thanks!

Agreed Jeff.

The trigger(s) caused a huge series of updates to several tables, logging, auditing, etc.

This was a one time update. We are a really busy shop..so 30G growth...

Hi Jeff,

Well it is fixed. Thanks everyone. I did run it with Gail's suggestion and it used about 30G worth of temp db space.

So for us, that was a...

Thanks Gail.

Trying this now.

Sure I did and the grouping is fine.

But after putting in the piece of junk dashboard software - I now think what I really have to have is dynamic...

I apologize Lowell.

I am not explaining this very well.

This query is going to be used for as part of a dashboard. Unfortunatley the dashboard software is kinda dumb and doesn't...

Okay my bad. I apologize. I didn't do a very good job of explaining what I am having trouble with.

I'm trying to get -

Number of APPROVED claims by username

Number...

OKay I checked every single group and he is not getting in via group membership.

I also know that he is using his domain account (domain\user).

When I run - xp

account...

Thanks Steve.

I hope MS considers this a need. I'm sure there are plenty of other folks out there that can't use the cloud for various reasons.

did you try changing the compatibility level to check for cardinality issues?

We have had many and some times the quick way to tell for sure is to switch it, then...

Thanks everyone for the input.

Okay, Fair enough. Thanks for the input. Didn't know there were some differences in the local version.

I think I can easily justify the use in our environment. I think...

Understood.

In our case, we have to keep records forever. So, the tables get large but the older data is rarely used. But we still need access to the older records...