We have an issue during failover where our production databases will go into Initializing state.  It is random, not consistent.  We've done a lot of investigation, debugging and are stumped. ...

Profiler is your tool. It will capture every database call, based on the events you select. You definately need RPC:Completed and SQL:BatchCompleted.

Ah poo, I must have missed this sentence:

"When the ForceEncryption option for the Database Engine is set to No, encryption can be requested by the client application but is not...

Thanks for you help all - the problem has been solved. This is the message I got from our network admin.

I was able to fix this yesterday after some...

Thanks everyone. We only have one domain. The user can log into this computer with no problem. Still searching....

Ufortunately, they did log off and the issue is still happening.

Unfortunately, CheckDB cannot fix this error. I tried:)

0808 (8/14/2008)

---

Here's what we did: Setup a daily scheduled OS task (not Agent!) that runs a .BAT file.

This .BAT file does this:

1. runs a SQL script that:

...

Problem solved, we will use TLog shipping but use the WITH STANDBY command so the data can be read.

Thanks All!

That was my first reaction was the data was different and I still believe it is data. I just wanted to make sure I wasn't missing anything. ...

@HowardW - please ignore my typo for the second query. What is important is the developer states the first query does not return data under 2K8 but does return...

Is there any performance gain when partitions are on the same set of spindles (can be same file group or different)?

Awesome. This is really timely. I just got Enterprise approved so I can implement partitioning and this series is going to be a huge help. Is the...

Good article, but there is not enough information.

How are these done?

"The first one is achieved by a rule called JNtoIdxLookup. The second requirement is a correlated loops join - also...

Thanks. The data is XML, but the stored proc parameter and destination field in the DB are varchar(max) so the parser shouldn't be loading.