It may not be your exact problem, but I think this article will help you.

Trying to Keep it short when writing on the phone. The uniqueifier cause the table to require a variable length block as well. So, in sone cases it is beneficial,...

Lynn Pettis (9/23/2011)

---

The best clustered index is really dependent on the data and the access paths to it. For instance, if you have a datatime column in your database...

Generally speaking, I'ld say this is not a good advice. I find...

Do you have a clustered index? If so, is it unique? Otherwise, updates can cause page splits. Aborter possibility, have you recently started to use row versioning (snapshot isolation)?

Basically: There is no way to do so. And, disk queue length is among the performance counters I rarely use. I would recommend that you take a look at Brent...

One solution would be to do it in SQL instead: Cast it to the xml data type and the use the xml methods (nodes/value etc).

XML Support in SQL Server 2005

May I suggest How to prove it's a SAN problem[/url] by Brent Ozar?

In High-Safety (synchronous mode) the principal will continue to serve the database.

http://msdn.microsoft.com/en-us/library/ms179344.aspx

Yes, you can. Cast the image column(s) to/from varbinary(max).

Ah, I see now. It uses mirroring for replication, so it's the same.

Disclaimer: I've not tested this in a lab, only read about it.

Each mirror (or seconadary if you want) can be set up to be updated synchronously or asynchronously. In addition,...

A bit late now, but I always recommend having a file copy of the master database, so that you hopefully never will have to rebuild it.

As far as I've seen, Always on is a hybrid between Database Mirroring and Clustering. It uses Clustering to maintain Quorum, and Mirroring to replicate data between the nodes. Due...

I would instead have the procedure return the three columns to SSRS, and then use formatting in SSRS. In that way, you could set for instance the text of column2...