Brandie Tarvin (7/3/2012)

---

GilaMonster (7/3/2012)

---

Sure. Will you finish off my...

Lynn Pettis (7/3/2012)

---

SQLRNNR (7/3/2012)

---

sqluser_8119 (7/3/2012)

---

Lynn Pettis (7/3/2012)

---

I'm going...

sqluser_8119 (7/3/2012)

---

Lynn Pettis (7/3/2012)

---

I'm going to throw out...

The truncate is performed via a checkpoint. Keep in mind that a truncate in the t-log does not free space to the OS. It is a mechanism that...

d'oh missed it because I inverted my answer.

What is your recovery model?

Does dbcc opentran return anything?

This article should help you understand:

http://www.sqlservercentral.com/articles/Administration/64582/

The old location is probably retaining size due to BLOBs that were in the primary filegroup.

If you have data that was in those tables that was in a blob data...

Is the user not able to list the tables out in SSMS? Not able to edit the tables? Not able to script the tables?

King

Here is something that could help you write a query to dedupe your data

http://jasonbrimhall.info/2011/03/21/dedupe-data-cte/

Michael Valentine Jones (6/30/2012)

---

I don't give much credibility to anything I read on the InfoWorld site, even when they're quoting another source.

They're just cheerleaders for the latest IT fads, and...

Seriously cool

SWEET!

Zumba