I will say we have a 1.9 TB database and we are in full recovery mode. We run transaction log backups hourly. we run with a 400GB drive for our...

We personally have a few hundred servers and over 1000 databases. I'm taking this time to review all space issues, fragmentation issues, what indexes are not working, what may...

Thank you. I appriciate all of the responses I've gotten. This is of great help.

GilaMonster (12/7/2012)

---

Files cannot be moved between filegroups.

If you want to move partitions of a table to a new filegroup, you'll have to create the new filegroup, create files within it...

I apologize, let me try this again. I have a single table that is in 25 files across 25 file groups. my issue is the final file is roughly 1.5b...

sqlGDBA (12/5/2012)

---

Doesn't the fact that you have 80% fragmentation mean that you're already using a significant amount of space over and above what is actually needed ? using a fill...

Doing a recreate is an interesting idea and will be addressed. I don't have the exact queries that are being run, but I was an application user at one point....

I agree, we're taking this work load over. right now it's a backup of production and it hasn't fully moved over yet. Trying to figure out the best ways to...

ignore the variable names >.>; apparently i have tables with hyphens in them and that just makes everything twitchy. this seems to work for now.

any advise on what i can...

I will admit, I'm a bit stuck on this and possibly over looking something very simple.

using the below script...

i get the below errors (errors first)

Msg 102, Level 15, State 1,...

i'm trying to ignore the sys databases. i just dont want to create tables on them either if it's not needed IE steps 1 and 2. step 3 still seems...

I found the below script works, though i'm still having issues with IF DB_ID(''?'') > 4

IF ''?'' <> ''master'' AND ''?'' <> ''model'' AND ''?'' <> ''msdb'' AND ''?'' <>...

i appreciate it, this was mostly to help understand how it works as well as get it working with as few options as possible. I will work with the other...

the main idea was to cut script time since these are very large and slower boxes. if cutting out all the extra script needed doesn't really provide any boost...

to be specific, the above scripts goal was to create a script that will create a set of scripts. i would prefer it to be reactive and repair as it...