Does the performance improve if you add OPTION (RECOMPILE) to the statement?

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

It could be parameter sniffing of some kind.

Just to clarify, the CURSOR is dreaded because it's row by row, bot...

It is by definition a row by row problem - whether it's a while loop or cursor is largely irrelevent.

I hope there's no user access to be able to...

Is it a specific query or literally anything that goes through the linked server?

E.g. Does something like this work?

select * from OPENQUERY(mylinkedservername,'Select getdate()')

I've found some random linked server problems (with...

The whole point of hashing algorithms is that they are not reversable. Unless there was a specific vunerability in the hashing algorithm you could not reverse it.

I'd suggest reading up...

I'd check with your license provider rather than make a guess at it.

Generally speaking the license covers previous version of the software, but the wording is:

Deploy SQL Server 2008, 2005,...

Print the @sql parameter and execute the text manually to debug it - it'll make life much easier

Are shadow copies enabled on the drive?

Edit: Never mind, you've already answered that

Show Hidden Files should be checked, not unchecked.

Make sure you can see hidden files and folders - have a look here for how to do that in Windows 2008:

http://social.technet.microsoft.com/Forums/en-US/windowsserver2008r2general/thread/4e3cfaa3-742e-41d4-bef5-39ccf9080e74

There must be more files than you're seeing...

I don't believe you can start a line with a slash in Oracle as it's a reserved character (for executing a batch) - take the carraige returns out and it...

Oracle requires you to have a FROM regardless of whether you're returning the results of a table - because of this, they have created a special table called 'dual' which...

PaulB-TheOneAndOnly (2/5/2011)

---

Let me translate, compatibility level will affect query behavior in the sense that query optimizer will be limited to the "compatibility level" you have set, it will not use...

I haven't got an R2 environment to hand at the moment - any chance you could post the DDL for the view you've created to test this?

Absolutely. In fact, this is one of the core parts of...