I'll delete the copy I downloaded, since you asked so nicely... 😉

See if you can get permission to post the stuff I asked for. Table defs, index defs, query and...

Careful... Those are suggestions and not always the best index or even a good idea.

Then I suggest you remove that execution plan ASAP, as I can work out the query, a portion of the table and index definitions just from that.

You can obfucate, change...

Please post query, table definitions and index definitions, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Drop the database and try the restore again.

You say the restore failed. With what error?

Oh, and if you've done your testing properly, you'd have found and fixed all the places where the app breaks on the new version, long before you migrated the actual...

However getting it from the plan cache is not reliable, as the plan...

eric_russell 13013 (5/12/2010)

Grant Fritchey (5/11/2010)

Whether the DBA knows it or not, that data can get changed by circumstances. It's best that you know that fact in order to gauge best...

Please don't cross post. It just wastes peoples time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic920437-150-1.aspx

Please don't cross post. It just wastes peoples time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic920437-150-1.aspx

Then anyone who has access to the hosted site has access to the keys and hence the data.

If you're using SQL column-level encryption then, unless you're encrypting by password, the...

Then you should note that we don't answer homework questions. We'll give you hints, but not answers. Spoon-fed answers teach you nothing. Have you tries asking your teacher/lecturer/tutor? for assistance?

Where are you storing the encryption keys?

May be of interest here - http://sqlinthewild.co.za/index.php/2010/03/23/left-outer-join-vs-not-exists/