You're using a couple of vague terms, so let me see if I can probe for more details. You start by saying that when you query it, it runs indefinitely,...

If you right click on SQL Server Agent in SSMS and then go to Properties -> Job System, is the box checked to use a non-admin proxy account?

It's not just you. The questions and answers lately have been very poorly phrased.

What sort of stuff wouldn't come with a full backup? That's sort of the idea of a backup - you get everything.

Is there any way that your connection could be getting interrupted? You mentioned that you're on a laptop, are you doing this over a wireless network?

Perform a transaction log backup. While this will not shrink the log file itself (though that is sometimes possible to do, depending on the circumstances), it will allow SQL Server...

Thanks. Totally worked for my application.

I'm sorry, but this is just bad design and you should push back to the developer to have them either list the included items in the package, or if they...

Not sure that I quite followed, but it sounded like you were setting READ UNCOMMITTED on the stored procedure that was doing the writing, not the reading. Is that correct?

Any reason why you couldn't just turn this into separate queries and union them together? You could just PIVOT them together if you need it all in one flat row.

The actual view is more complicated and makes selections from table A, as well as a few other tables.

I guess my main curiousity is in regards to the index scans...

This is why people don't like DBA's.

Nice. Thank you.

In this example, I could. In my real-world issue, this is not an option. What is the actual problem with this?

Well, that's the problem. Like I mentioned, the users are able to build their own expressions through our UI and keep any number of them that they want. I know...