You can blame me for that. I picked Buffalo in my Surival league because how could they not beat the Jets?

In one of my leagues, I had Aaron Rodgers with DeShaun Watson as a backup. I'm now starting Jacoby Brisset in that league. 🙁

Make sure they meet the qualifications for using Kerberos and if the problem persists, then run a Kerberos and NTLM trace to find out why it's defaulting to NTLM. You...

I only saw 1 person in there other than myself.

Or in other words, "I'm in".

As a former consultant, I am still in contact with a few of my ex-clients. I know of at least 2 very high profile companies who were not hit by...

Can you outline the steps you took for "we have already restored the appropriate thumbprint"?

It depends. Are you running SQL Server on the physical machine or just the VM? If you're running SQL Server on both, you either have to license for unlimited VMs...

I notice that the QA plan parallelizes out much farther than the first one. How many logical CPUs does each have and what are the max DOP settings?

Are you using Change Data Capture? CDC forces it to do record level replication.

https://blogs.msdn.microsoft.com/repltalk/2013/04/28/cannot-replicate-stored-procedure-execution-when-cdc-is-enabled/

I have a blog post detailing how to do this very thing: Smart Pivot Tricks: Multiple Pivots, Aliases, Dynamic Pivots

You need to build the column names dynamically, pivot twice, and...

What version(s) of SQL Server and what architecture (32 or 64 bit)?

What are the memory settings for your SSRS instance? (see https://technet.microsoft.com/en-us/library/ms159206%28SQL.100%29.aspx)

You could also try setting the “appdomainmanager” trace level...

SSRS running slow is quite often an indicator that it needs more memory.

Appdomains unloaded is a clear indicator that it needs more memory.

Reduce max server memory to 40 GB and...

KSQLDBA (12/16/2015)

My data are field base in another words I will say the similarity is only on the...