I always wince when I see stuff inserted into a staging table, only to be immediately deleted.  It's usually more efficient not to insert it in the first place.  Try...

You could set up an Extended Events session and capture oledb_provider_initialized.  Presumably there are similar events for other providers, in case any of your linked servers don't use OLDEB.

John

Alex

Might be worth changing the block size to 64KB from its default of 4KB.  Also, speak to your SAN administrator about whether putting log files on...

From those numbers, it looks as if most of your waits are to do with disk latency, with a little bit of blocking (possibly caused by the disk latency) thrown...

Alex

Have you analysed your wait stats?  That'll help you understand whether it's CPU or disk - or it could be something else, such as blocking.

Incidentally, I...

You've already written the query - what's wrong with it?  I'm guessing you don't know because you haven't actually tested it.  How do I know that?  The DDL and sample...

There appears to be a syntax error in the last query, at least.  So make sure you run them and that they return the correct results.  You will, of course,...

The error message is helpful in cases like this.  In its absence, I'll guess that it's because the two result sets don't have the same number of columns.

John

One way is to create a calendar table (either permanent or on-the-fly) and join to that.  You'll get much better and answers much quicker if you post table DDL and...

Sounds like a classic gaps and islands problem.  I don't have a tailor-made solution, I'm afraid, but the page I linked to should provide a few pointers.

Do you mean can you have the SSRS service on Server A and the databases on Server B?  Yes, you can, but bear in mind that you need to buy...

What do you mean by "access"?  Do you just want to run a browser on Server B and run reports from it?  If so, yes, that can be done.

It doesn't have to be an explicit conversion - it could be an arithmetical operation that exceeds the maximum value for the int data type, for example:

[code...

Are you really on SQL Server 2008?  If you're on 2012 or later, you can use the LAG or LEAD function, which will make it a lot simpler.

John