I don't think you need to shrink it to share it with a bunch of developers efficiently. Go get a copy of Redgate's SQL Clone.

http://www.red-gate.com/products/dba/sql-clone/

https://www.simple-talk.com/sql/sql-tools/clone-sweet-clone-database-provisioning-made-easy/

Tell Richard I sent you!...

Late to the party, but I have had very good success with value-driven-index-seek based deletes (where possible) too.

j-1064772 (9/15/2016)

---

Again, another example of multiple senior contributors moving the goal posts farther away to better explore the subject,...

No worries mate! Glad I could help.

Check to see if anything is running currently before you start the restore. Wait a bit if they are. Decide if you want to kill them and force the restore...

Sheesh, I missed that too, but based on the OPs code they would certainly have been able to get the right aggregated output thankfully! 🙂

Mike Scalise (9/14/2016)

---

Hi Kevin,

I've been looking into log-shipping since, honestly, you have me a little scared about the potential performance impacts of mirroring and transactional replication.

It seems to be a...

sqlenthu 89358 (9/14/2016)

---

Hi all, I have to transfer around 50 million records from one table to another. What should be the best approach. I know it can be done batchwise...

CROSS APPLY VALUES #FTW!! Nicely done Jason. 🙂

Run sp_whoisactive and get some of the additional stuff it can show you and see if anything makes sense then.

Hence the "almost" ... 🙂

drew.allen (9/12/2016)

---

ROWS won't work for the overall total here, because the...

Sounds like you know what you are doing Steve. Kudos for you! Do note that we don't get a whole lot of that on these forums (because if they did...

SQL Diagnostic Manager offers lots of options for showing you what queries are eating various resources.

ROWS is (almost ?) ALWAYS offers MUCH better performance than RANGE! Try your best to use ROWS when possible.