Given that it's a sproc based on several views, you could also try to compare the before and after performance of the individual views. e.g. if one view suddenly...

Not clear from your post where Views come into it? (Yet you mention them twice.)

Can you please explain more fully.

Two other options are

1) replication

2) SSIS or similar which can hold connections to both servers

Thanks Ioannis,

I think you should test 'write for us' some more!

Looking forward to a first article.

Not sure that I'll ever have to use your functions (I hope not!) but I was intrigued by your code to verify the existence of the function before creating (in...

Top marks for the stored procedure name!! As for the rest, there's not much sql in it! More a lesson on how to issue dos type commands via...

Hi Steve - good topic!

I'm a heavy user of synonyms -- in fact for every external database access whether on the same server or not.

My world is one...

You've hit the nail on the head, Phil....which is, of course, preferable to hitting the keyboard with the head.

Unfortunately, I usually have to reach the point where the metaphorical keyboard...

Very clear and nice writing style....thanks.

..probably permissions related. Does the account under which the sql agent service is running have the necessary permissions on the database?

Thanks Cem, good to know. This 'data quality services' looks like one to watch. But it seems to me you could have achieved the same result as in...

Unfortunately (or fortunately) the last occurence problem can be better addressed by using charindex with the built-in reverse function. More importantly there is absolutely no reason to use such...

Sorry Marco...I was being sarcastic. Generating a chart in HTML is way outside of the scope of this article / discussion.

As a general guideline, I would advise that you...

Just click the 'display as chart'...

Your mother just turned 50, and...