Let's start with the basics before we even look at the logic of your query:
(1) Why are you passing in dates as varchar?  You only need two parameters here:...

Another alternative, if it's an option for you, is to create a new schema.  Call it something like ReadOnlyProcs.  Put all of the stored procedures you describe into that schema...

Eamon

No, views don't have parameters.  A stored procedure would work, although you'd need to use dynamic SQL.  Make sure you understand, and guard against, SQL injection if you...

Indeed, and regarding tables getting loaded into memory, that doesn't necessarily happen at all.  If the query optimizer finds a suitable index, that index will be used and the table...

Adil

Go with the syntax that Anthony posted.  Like he said, it'll only have a small effect on the database, and it's certainly preferable to not knowing about corruption...

You could use the Windows task scheduler instead.  By the way, don't back up to the C drive.  Make sure backups go to a different disk from the operating system...

I typed "sql azure freeproccache" into my favourite search engine, and I found this.  Does it help you?

John

How do you determine which Code1 is matched with which Code2 and which Code3 in your result set?  Will all codes always have the same number of elements in?

Are any of the file names longer than the 30 characters you've allowed for in the #Dir table?

John

Please will you post the actual execution plan (.sqlplan file) for your query when you run it against the full data set?

John

What is the exact name of the performance counter they're reporting on?

61 out of 64GB seems rather high - you need to leave some for the operating system,...