Thanks.

That worked.

For future searchers, here is the msdn link http://msdn.microsoft.com/en-us/library/ms188332.aspx

Ah ha moment -- so I didn't realize that

"TRUNCATEONLY

Releases all free space at the end of the file to the operating system but does not perform any page movement...

It's the data file. All of the db's i'm working with are in simple recovery mode.

I...

Thanks Gail.

That's what I thought about restoring a backup -- that it would replace the new db with all it's settings, but I wasn't 100% and that's what I just...

Thanks Gail (another honor)

I think I got it. I can't do a diff If I don't have the full that it was created from.

Cooley high.

Just some background...

Thanks Steve,

First, it is an honor to have you respond to my post 🙂

I understand that tran log backups can be restored in order skipping over any intermediate full...

thanks Ninja's_RGR'us

I scanned those links and I will read them more in depth along with some others i've seen.

I will definitely use your advice on the RAM .

Hi Again,

I don't have my disk stats in front of me. When I first started helping out, and i'm not getting paid a lot to help, I did all the...

Thanks all for the advice. I have been saying to the client the 'best' practices for over a year, but it is a really really small startup and just getting...

i believe brent ozar also mentions this in his performance tuning for race car drivers video. he mentions the overlapping stats and some other good stuff. (but not much...

thanks for the responses. this was the kind of information I was looking for.

I didn't want to drop any of the statistics unless they were not used.

I don't know...

I've always eaten lunch at my desk while working and normally i use my 'lunch hour' running errands or doing something personal. So i'll run an errand and maybe pick...

Actually it's not really worth it, the server isn't even dedicated to SQL Server, so I keep saying I don't think just running a query would max out the memory...

Well the reason that it's dynamic is because there are a few tables with the same structure that he's using in the the 'from' clause.

so the idea is that...

@cfradenburg (thanks for the info above --forgot my manners)

One last note, the client isn't developing using a 'standard' the schema on tables can change on a whim, etc...

so I checked...