Thanks Gail!

My plan is:

1. Compress the Clustered Index / Data

2. Shrink the file

3. Rebuild the Clustered Index

4. Compress and rebuild the non-clustered indexes

Once more, thank you!

Jason

Hipster

Evil Kraig F (5/13/2013)

---

So, I don't feel that I'm doing one of our posters justice on a topic he's posted. I've gotten a very polite blow off. Not...

I've run into the same error where I work, and while this may not be the case for you, maybe it'll help.

The problem was, the users getting this error (not...

Thanks all!

I am going to be *SO* useless the 24th at work...

Or as several co-workers have commented, "more than usual?"

:hehe:

14 days and change until I start my 2 week vacation...

18 days and change until I'm touching down in Jamaica for that vacation...

18 days and a bit more change until...

You just had to post this, 19 days before I'm going on a flight...

I do think, however, that your thought of two flights, same day, same flight number, different times...

ChrisM@Work (5/9/2013)

---

Stefan Krzywicki (5/8/2013)

---

jasona.work (5/8/2013)

---

You know, having a window at work can be both a boon and a curse...

Boon because, especially if it opens, you can get fresh air, bright...

Stefan Krzywicki (5/8/2013)

---

jasona.work (5/8/2013)

---

You know, having a window at work can be both a boon and a curse...

Boon because, especially if it opens, you can get fresh air, bright sunshine...

Curse...

You know, having a window at work can be both a boon and a curse...

Boon because, especially if it opens, you can get fresh air, bright sunshine...

Curse for the exact...

The benefits of inheriting a SQL infrastructure and having to hit the ground running at full speed...

You occasionally get nice surprises from things you didn't...

Well, thanks for the suggestions, but continued research, come to find out the other DBs on the server live on another drive entirely.

Plus I freed up ~40GB by deleting my...

I love it when I find out I don't need to do something I thought I'd need to do because of something I did...

I'm all set to shrink a DB...

Gotcha.

If it weren't for the disk space, I wouldn't be bothering with this, but...

Come to find out, part of the reason this wasn't an issue with the previous table is...

So just one big shrink operation, rebuild the CI and NCIs, and done, correct?