Yeah, we do index rebuilds quite often but I am not 100% sure. but definitely that could be one of the reasons.

Jeff, I got your point. Could you please...

My two thoughts on things like this continue to be...

1. Change is inevitable.  Change for the better is not.
2. If you want to learn something totally new, then try learning...

Thanks for the article, John.  I'd like to do an experiment with another method.  Can you identify the 3rd party link for where to get the source CSVs from, please?

This is how my table looks except I used random numbers for my values. Some of the dx columns have values and some do not. How about actually showing...

Please see the article at the first link on how to provide some readily consumable test data to help you help people help you.  It also saves on many questions...

700GB log file for a 5TB database?  Have you determined what caused it to grow that large and, if you reduce the size, will it grow to be that large...

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...