Ditto what Frederico said.  You've already identified the problem queries.  Check the execution plans for them and fix them.

I'll also say that if you have to remove data from a...

Currently we are collecting database statistics information using

select * FROM sys.dm_db_index_physical_stats( 14, NULL, NULL, NULL, 'SAMPLED')

For some larger databases this statement takes more than...

p.s. Page compression includes Row compression, which basically turns a lot of "fixed width" datatypes to "variable width" and that can cause HUGE performance and log file problems due to...

Heh... you just had to know there was going to be some spam involved after the 2 new one-off replies that mostly didn't say much. 😀

Synonyms.  Views.  Joins that use...

Currently we are collecting database statistics information using

select * FROM sys.dm_db_index_physical_stats( 14, NULL, NULL, NULL, 'SAMPLED')

For some larger databases this statement takes more than 23...

Heh... I work with a "Director" that I've worked with for nearly 2 decades.  He had a sign on his wall that said...

"Piss Poor Planning on YOUR part DOES constitute...

We're not joining to anything local, fortunately.  We're literally just dumping the contents of reporting tables on our server to a tables on their server - the only difference...

Ok... on that note... it's a bit ironic having a RedGate employee talk to us about "Giving it away" when the very forum such an article is on has seriously...

Thumbs up on that.  That...

Thanks for the quick reply Jeff!

Do you use Auto update stats? And for critical tables full scan with norecompute? And update these weekly? Or just full scan all stats...

I rebuild stats once per week.  Because most of the clustered indexes are "ever increasing" in nature, I use the "if it moved, shoot it" approach.  I also use full...

First, that's an insanely expensive server and you good folks have crippled it with 150GB of RAM.  You...

@ Steve and @ Jonathan,

There is no question at all in my mind that the smart company will invest in it's employees.  That's not the issue I'm speaking of.

My bitching...

I see many people that site things like a lack of training at work, etc, etc.

Tell me... if you have a degree, who paid for it?  How did you get...