Is this an export or report created out of a mainframe?  This is strangely similar to a situation I had to work on a while back.

Reading this thread, the issues...

I have to admit, I'm totally amazed about the number of people that participate on the QoD and on Polls on linked in.

I'm also amazed at the number of...

Though its Azure MI Business critical , I see fragmentation, Any script to identify which IX's need to be rebuilt ,as Frag is over 50%.

I will add REBUILD WITH...

I am very curious why you decided to perform an in-place upgrade instead of starting with a fresh install and restore of the databases to a new server?  Especially with...

Hi there, I have this situation that I have been trying to get around for some time but I haven't been able to despite some considerable investigation. I have...

Seriously?  If there was such a magic button, don't you think MS would have provided it?  Tell...

I have the same question.  It sounds as if you are rebuilding indexes.

Second, these scripts perform an update statistics on the table with a full scan.  A table typically has...

For starters, the defaults that are built into Ola's scripts are based upon Microsoft's recommendations. Guess what.  MS...

Snapmanager for SQL allows you to database level backups and avoid the OS freeze. We implemented it as a solution to back up a 3-4 terabyte sharepoint site database...

Also, as reindexing cycle takes several month, and business is quickly growing and we have more data, there are too many variables.

At least we keep all SLAs with growing...

I am aware of that effect. We do update stats which changes (sometimes) execution plans

We monitor Query Store a lot for regressed queries and check for execution plans change.

As...

I am using COMPRESSION=PAGE

Even without COMPRESSION, tables become 1.5-2 times smaller after rebuild

With the compression, below is the extract from the output of my script. You can see, sometimes...

VSS snapshots are SQL consistent and the feature no longer requires SQL Enterprise. They are supposed to be very fast - they may not be fast without adequate maintenance,...

I wanted to share my findings with you (and a script)

We have 24/7 workload with no downtime, up to 200K IOps, multiple databases 10-20-30Tb, on few servers 80Tb total.

I...

80 TB total.  The server that contains the databases I referenced above total 48 TB.  The entire server completes in approximately 12 hours.

Backups execute in parallel,...