If there is any data you would be upset or in trouble for if it got leaked, I would encrypt it.

My opinion - there isn't anything worth stealing in the...

One approach that MAY work for you would be to break it up into multiple steps.

Since pulling the inner queries into a temp table improves performance, why not just use...

Looking at the execution plan, I am thinking that adding an index on SubscriberID may help as you are using those in the WHERE clause.

Your estimated number of rows is...

There is a good article on checkdb here:

https://www.mssqltips.com/sqlservertip/2399/minimize-performance-impact-of-sql-server-dbcc-checkdb/

I do recommend you read that as it addresses your concerns with PHYSICAL_ONLY as well as using the backup-restore-checkdb approach.

The best way to work with performance issues is to look at the execution plan.  Could you post the execution plan for your query?

When I run the above, it is...

• This reply was modified 4 years, 1 months ago by Mr. Brian Gale.

Alternately, rather than dropping the tables and recreating them (not a process I generally do in a stored procedure), how about doing a TRUNCATE/DELETE at the start and an INSERT...

One approach would be to modify them and add in a logging table to capture when the stored procedure is called.

Another way would be to start a profiler trace and...

Since you get an authentication error, I would be willing to bet the problem is with the authentication somewhere.

Did a quick google, and found this:

https://www.liquidweb.com/kb/troubleshooting-microsoft-sql-server-error-18456-login-failed-user/

Not specific to Azure, but should...

I think the problem is that a CASE statement cannot return 2 values like that.

The idea of a CASE statement in SQL is that if the lookup value is X...

For me, I don't manage the hardware side of things, so I care less about the hardware and actually have very little say in what hardware I get.  It is...

You say you are using an application - is there a reason you are not just pulling the Excel data in through that rather than using SQL Server as a...

To me it looks like your statistics are out of date.  Your estimates are WAY off from the actuals which usually indicates bad statistics.

I would start there.

Another thing - I...

I agree with both Phil and Michael.  Phil's comment about query store sounds like it is similar to Oracle's AWR.  Or so is my my understanding of query store.

And Michael...

My opinion - I wouldn't reinvent the wheel.  There are a LOT of good monitoring tools out there and I would just use one of those.

The good SQL monitoring tools...

Script debugging is always interesting.  The "best" (ie only) way I know how to do it is to find good breakpoints and run your code up until that breakpoint.  Next,...