If there is an index behind the stats, then stats_id is the same thing as the index_id in sys.indexes.  Do an outer join to sys.stats from sys.indexes to make that...

Looks like the OP has left the building.

So were you able to remove the file group after that?

I'll echo ZZartin's questions and ask one more... how big is this clustered index in rows, columns, and GB occupied?

To be honest, you should already have a script that does this because you should be testing your backups on a regular basis.

There are a lot of scripts out there...

Hehe - until...

Along the same lines as "a car can't fly". Of...

Now there's an interesting hypothesis... I wonder how one would prove that. 😀

I do get the spirit of that statement, though.

Bulk Insert uses...

This sounds interesting.  It would appear that the "auto bumping" mechanism failed to bump your unanswered question.  I can't help here but I can bump the post for you by...

One of the attacks that a hacker will sometimes make on you is accompanied by brute forcing rollovers of the SQL Server Error log so you can't figure out what...

The files all have the same prefix before the time stamp.  That means they'll sort naturally and you don't need to split anything out of the file name to process...

The article recommends doing a cume on the "ghost_record_count" of sys.dm_db_index_physical_stats.  It shows no ghost records, which is what I expected because of the very low page counts for the...

Again, interesting read... I knew of the ghost process but never did a deep dive on it.  I had no idea that it could be disabled and that it would...

Not...