MysteryJimbo (3/20/2014)

---

humbleDBA (3/20/2014)

---

It is 'true' replication as it uses Transactional Replication. The main difference is that when the subscriber updates, it makes use mechanism to re-direct the subscriber update...

MysteryJimbo (3/20/2014)

---

I've used this before...

This sounds like something I had to do many years ago. Back then I used Transactional Replication with Updateable Subscriptions. Might be worth a look.

On top of what Gail has said, depending on the DB you are carrying out the Shrink work on - its size, how many indexes, etc. - you may experience...

Jeff Moden (3/18/2014)

---

MS actually does have "TempDB in RAM" today. It defaults to that and only spills to disk if it gets too large for a given session. ...

mike.gallamore (3/18/2014)

---

That doesn't really clear it up for me. She talks about rolling back the same transaction that the truncate was done in. There are exclusive locks: "and just like...

mike.gallamore (3/18/2014)

---

Well there is logged and then there is logged. I seem to recall from by db courses and anywhere I've read online: ex. http://www.mssqltips.com/sqlservertip/1080/deleting-data-in-sql-server-with-truncate-vs-delete-commands/ that the deletion...

mike.gallamore (3/18/2014)

---

+1 truncate. I ran into it recently but there is one cevate: if the table is referenced by foreign keys you can't truncate (even if the FK constraints are...

Guess no-one remembers sp_configure 'tempdb in ram' and DBCC PINTABLE... Gezzzz I'm getting old :crying:

But, hey, what goes around, comes around... feeling better now 😛

Siberian Khatru (3/14/2014)

---

humbleDBA (3/14/2014)

---

GilaMonster (3/14/2014)

---

Well....

Both delete and...

GilaMonster (3/14/2014)

---

Well....

Both delete and truncate can be...

Eric M Russell (3/13/2014)

---

Siberian Khatru (3/12/2014)

---

I have a table with @ 20 Million rows of data I want to truncate or delete. I don't need any of the data...

A nice article, Grant, and though its old it still has something that is timeless...TESTING!!! A lot of effort was put in for...

And likewise...a FK does not have to link to a PK, it can equally link to a unique clustered index constraint...

From Technet

"...you can add a FOREIGN KEY constraint, provided...

+1...