GilaMonster (6/29/2012)

---

ben.brugman (6/29/2012)

---

Technically it would be possible to use the information from the clustered key in addition to the extra key, while not using the first part of the clustered...

Thanks for providing the links.

I do understand indexes, both clustered and heap.

I do not always understand behavior of the optimizer combined...

GilaMonster (6/28/2012)

---

When doing updates to index keys, SQL does not do them as inplace updates, they will be converted into a delete/insert pair. This is why one of the guidelines...

Thanks for your anwsers.

At the moment I am trying to convince my organisation that Clustering would solve a lot of the problems we have at the moment and would improve...

Thank you all for the replies.

Now I can convert most tables ON-LINE. Great.

Do you have suggestions for the tables containing LOBS.

Or is there is way to do this on-line by...

GilaMonster (6/15/2012)

---

If you're on Enterprise Edition and there are no LOB columns in the table, then you should be able to create the clustered index online with the ONLINE option...

Thanks for...

Thanks,

this wil help us with planning the...

Grant Fritchey (6/4/2012)

---

When all you have available is the full backup, that's all you're going to get. If you have log backups available, you can restore right to the end...

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