I have to take acception to one of the comments above. The selection of simple vs full is not made based on when you do a full backup. ...

When setting up a backup strategy, I look at a few things.

How much data can I afford to loose?

How much disk space do I have for the TLOG?

Where am I...

During some testing with our clients prior to the release we maxed out at 20 GB per day growth. We are now releasing it to US and Canada with...

For years I was a contract DBA. My job required going in finding and fixing problems most of which where related to poor practices. Today I manage a world...

Nevermind...

I connected directly to the server via rdp and it all worked fine. Not sure why, but will chalk another one up to experience.

Also, no messages at all in the event logs for SQL or Windows related to Failed Mirror setup.

We are using ADO.Net within our ASP.Net pages. One thread process per IIS Server to handle the data transfer every 2 minutes. Monitoring the process it looks like...

Thanks, that is what I would have expected. CharIndex would create a situation that invalidates the Index View and basically forces SQL to the underlying tables.

But this does...

Wasn't sure about CharIndex since it can return a null value and which could invalidate the index statement for the view. Has anyone ever used CharIndex on an indexed...

I used a char(15) data type with a rule for format.

Not too concerned with drive failure as we will be on a high end SAN with lots of fault tolerance and access capabilities.

We will also be using MPIO and each...

Windows Clustering is NOT network aware, except for the Heartbeat between the servers. If the network were to go down and the private heartbeat network is still up, Windows...

Thanks, I was pretty sure that the order and number of columns for the include columns didn't matter, but I wanted to get some second opinions.

Have a great weekend. ...

You are correct on the selecting an index as a 'candidate index' to be used. Only the index key values are used. However, after an candidate index is...

I just created a logged csv file for these counters and had no problems. Have you tried this on another machine?