I guess your query uses buffer_descriptors joining with allocation_units views.

No, it does not mean that it's not using indexes. It may use indexes for index scans or seeks, but...

It is very strange to hear that a DBA applies for bunkropcy. We are highly paid professionals who receive much more than the average value in the country, must be...

For data file: try to shrink by small chunks. For example, it your total size is 340 GB, run dbcc shrinkfile('file_name',339900), and than check space again.

For log file: run dbcc...

As author noted, all partitions assigned to the same filegroup, so it won't physically move the rows, it will just re-assign partitions within.

You can play with has_backup_checksums column in msdb..backupset table

Yes, I have in my code: where t.name = <my_table_name>.

But the level of fragmentation is so low, that my script skips it. And this is exactly the reason why...

Yes, it's always backed up periodically.

DBCC shrink file did not help. First, it shrinks entire file which also has other tables. And it shrank just little bit because there was...

OK, let's assume that I am not in production. How can I increase fragmentation without modifying the data?

This server is used by 3rd party applications and not frequently used. I want to debug some rare case in my defragmentation script, it happens only in a adatabase that's...

Thanks both for quick reply. Big thanks to Nevin. It worked.

There is no such an option in creating a trace for how many days to keep it. You can only specify size and how many files to keep.

In your sitaution...

You can't move a file from filegroup to a filegroup. But if I understood you correctly, your ultimate goal is not moving the files around, but to get rid of...

Aparently the topic starter meant a book called "SQL Cookbook" and how to install examples from it.

Employee or consultant, it's not such important how I am called. But here is the situation, and I'll try to explain it as clear as possible.

I am employee of...

It is partitioned accross multiple filegroups, and each FG has only one file. But me error message points only to the very first file in this partition scheme.