Benki Chendu (9/22/2016)

---

Hi All,

I was asked this question by one of my customer.

He wanted me to give him a rough idea about the effort to configure Logshipping/Mirroring/Replication/Always on ,...

Very slick Sergiy!! An elegant yet exceedingly simple solution to this need.

What was the ACTUAL blocked resource? Are you absolutely certain it was blocking and not latch contention or something else?

I like sp_whoisactive to see lots of details about such things....

ghughes (9/21/2016)

---

this is what I can do. I can write some sql, that will produce some tsql alter statement to a function that is driven by the bad...

Nicely done Luis. I completely missed that in nesting the REPLACEs you can make them operate in the order you want and thus could wrap this up in the desired...

1) You can probably save some CPU ticks if you nest REPLACEs up to whatever level they can be nested instead of doing that many separate SET statements. This savings...

If you really want trace flag 4199 to apply to just one database you are limited to modifying every query in said database you want it applied to and apply...

Just found out while doing research that some other RDBMS' have this functionality built in!

Also, Adam Machanic suggested a CLR UDA, and I found such on codeplex

https://groupconcat.codeplex.com

Not sure I can...

Those are both rather gross (especially yours Eddie!!), but they do seem to give the right answer at least. Given I will have N columns and M rows I don't...

Please...

andrew gothard (9/16/2016)

---

While obviously not expecting...

Grant already addressed the data distribution/development stuff.

I would think there is the potential for iterative shrinks to actually take a lot longer. Shrink works by moving pages and I don't...

I honestly haven't used PLE as a metric in probably a decade. Avg disk sec/read and avg disk sec/write are WAY more appropriate IMHO.

I will disagree with others about reducing the data being a good thing. Obfuscation sure, but ONLY where REQUIRED.

The OP stated this database was to be promulgated to developers so...

Jeff Moden (9/15/2016)

---

TheSQLGuru (9/15/2016)

---

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...