All your partitions are in the same filegroup. What you are trying to achive with partitioning?

Do you have VIEW ANY DEFINITION permission?

Question: if my database files sit all on one drive, will my query benefit from parallelism (even if query cost > threshold)?

Check the following things in production:

1. Blockings.

2. Resources (CPU, memory) consumption by other processes.

3. Index fragmentation.

4. Whether statistics is fresh.

5. File-system I/O througput

You don't need to put it in a separate script - just comment create procedure ... as begin,end, etc.

Author's ultimate goal are blockings. If nothing blocks his report, he does not need to care about held locks and open trans.

If you don't have any FK referencing your PK, you can add this column to PK and partition it.

However, if you have FK from other tables referencing your PK, you...

If you partition a table: YES.

If you partition just an index: not necessary.

Did you have blockings?

select * from sys.sysprocesses

where blocked>0

Try to backup with compression. In this case, the combined backup size will be around 150-200 GB, so there is a chance you'll be able to find a space on...

1. Go up from your point where you select from @SystemComponentTbl.

2. Find all occurances where data is inserted, updated or deleted from it.

3. After each of such query, put: select...

Maybe it would be easier, but I have several servers: dev, test, UAT, prod. In order not to mix, I have one SSMS per server, with color-coded status panel in...

On server hard-disk, try to find this file whether it exists there at all. Try to delete it.

Unlike Files, the Filegroup is only...

Is your database partitioned ?