Question 1 - As far as I am aware, three is no limit on the SSRS side, but there is a limit in how long the URL can be -...

How much free disk space do you have?  Can tempdb grow?

Also, is that 200MB the data size, the log size, or combined?  Knowing the individual values would help.

Lastly, what are...

With my experience, installing CU's or SP's via WSUS is a slow and painful process where it happens one instance at a time and generally needs a reboot between installs.

I...

This sounds like a better question for your licensing provider than a random forum post, but I can try to help here.

Best I can tell, there is no difference between...

Just to confirm - the totals when you run it unfiltered are NOT showing up, but when running it filtered, they ARE showing up?

If the above is correct, I would...

As a guess, could it be permission related?  I am wondering if you are running it with a restricted account and you need a full sysadmin to see all of...

Something I'd like to add to what Jeff said - where do you want to handle this?  Should this be handled at the INSERT level or at the SELECT level?

Also,...

A quick google of this, it looks like CONTEXT_INFO is not a property that is available at connection time.  So you would need to SET that after connecting.  This could...

Glad I could help.  I am actually a bit surprised that SSL connections would be faster than non-SSL.  I am actually not sure why that would be as SSL adds...

Quick google of that error, it sounds like there is more to the error message.  Is the full error message:

Msg 8921, Level 16, State 1, Line 1 Check terminated. A...

I see a few optimizations that can probably take place.

First, that WHERE 1=1 isn't needed as it isn't doing anything.  Not sure it is a performance improvement by removing it,...

One way to do it that I think should work would be to do a self join.  So something like:

SELECT
[t1].[empID]
, [t1].[empl_rcd]
, [t1].[jobcode]   AS [jobcode1]
, [t1].[joblevel]...

For me, with my android device, I like that I can turn off targeted marketing.  I forget where the setting is, but google allows you to disable it.  Turning it...

I can think of only 1 case where a BEGIN doesn't have an END - BEGIN TRANSACTION.  That requires a COMMIT or a ROLLBACK.   Otherwise I agree with Jeff here...

Few things I would try, but the first would be to connect to the server using the FQDN rather than the friendly name.

I would also make sure your connection string...