Grigore Dolghin (2/25/2011)

---

I am afraid this approach is even worse. What if for each of those keys the developer has to insert some records in a related table, then use...

I think your solution is really good. One more time DBA has to solve issues caused by developers that do not know that database calls are expensive and locking is...

Do you think that Microsoft will work on supporting Filestream with mirroring in near future? I wood like to be able to use both technologies.

Nice script. I looked at it and found two improvements that you can make. First you can replace:

if @first = 0

begin

...

Hi there,

the script will be better if the current fillfactor for each index is saved and reused when the indexes are rebuild.

Good Article David,

do you think you can change the method to use CDC in SQL2008 instead of triggers? We all know why we do not want to use triggers.

The...