If it's two different plans, that's probably the issue.

Make sure the same parameters are in use on both and make sure that both have updated statistics and defragmented indexes.

The very...

Different parameters?

Nope removing the certificate didn't fix the issue. That makes me feel better. There must be an alter database statement that removes the reference to encryption.

Nuts. I might have been premature in posting to Connect. I finally found another reference:

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=351548&wa=wsignin1.0

I'm testing removing the certificate now.

I posted it to Connect:

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=423249

You can vote on it, set the priority, add your comments, especially since this is your issue.

I'm going to keep hacking at it as time allows.

I hit the same issue. I went back to retest and now I'm hitting the issue on the test database, where I didn't hit it before...

I'm trying to track down...

I think that's a torn page error. Try running a consistency check on the source db.

Yeah, congrats.

I confess I saw a tweet from someone over there...

Lynn Pettis (3/12/2009)

I just sent "she who must be obeyed" the link you...

GilaMonster (3/12/2009)

Yup. It factored into my decision to 'challenge' him. I'm curious how he's going to reply.

Rule 1...

GilaMonster (3/12/2009)

It's available on...

Yep. Just did. Works great. Turn on encryption on one machine, including setting a certificate and enabling it on the database. I ran a backup from there that was encrypted....

You want to use the datepart function. You can look it up in BOL for all the permutations, but it basically works like this:

SELECT DATENAME(yyyy,'3/12/2009') AS 'Year'

MS says that less than 1000 pages defragging won't help... that might be true, but if it's less than 8 pages, you can't defrag at all. Setting a fragmentation percentage...

The structure and the query are the driving factors. You've got an open-ended query with no well defined WHERE clause, so it's going to be hard to index it properly,...