The hit ratio

SELECT '--' [--], cntr_value AS 'xhitx', CONVERT(varchar(30), getdate(), 126) as TIJD, '>>>'+counter_name+'<<<'...

Thanks for pointing out this technique.

I knew of snapshot isolation but this is used differently, I guess.

Other...

To which snapshot technique are you refering?

We have a single development database but about 20 developers...

Thanks for plan B.

Found a similar plan C:

Plan B => http://www.idera.com/Products/SQL-toolbox/SQL-virtual-database//

Ninja's_RGR'us (11/14/2011)

---

Any reason why they can't do a copy of the db overnight (backup / restore).

Then...

Gianluca Sartori (10/13/2011)

---

External applications generally invoke the procedure and determine the result sets shape from metadata.

You can use a "dirty trick" to achieve the same thing:

With this linked server in...

Thank you for your time and answer.

In our situation OFF produces a 'fatal' error, and with ON the select get's completed.

The provided link does describe the Set errorabort, but the...

Sean Lange (9/29/2011)

---

Welcome to SSC. snip snip. On particular challenge with storing dates in varchar fields is what does 1/1/2011 mean? Is that Jan-1 or 1-Jan? That will depend...