You license the SQL instance based on cores (or server + CAL depending on edition). Nothing at all to do with what linked servers you have to where or how...

Yup.
https://blogs.msdn.microsoft.com/mspfe/2012/11/08/using-distributed-replay-to-load-test-your-sql-serverpart-1/ 
https://blogs.msdn.microsoft.com/mspfe/2012/11/14/using-distributed-replay-to-load-test-your-sql-serverpart-2/

Just don't use Profiler to run the trace. Generate the script from Profiler, and run the script to generate a server-side...

Err, no. There's not reconfiguration required to run a server-side trace.

You might need another server (little server, nothing powerful) with the Distributed Replay tools on it to replay...

What do you want help with?

No. it's not. See the blog post I referenced.

Most of those tests are IO-bound, not testing anything else.

Capture a workload from your current server using  server-side traces. Run it against the new server using Distributed Replay....

Please note: 7 year old thread.
And those 'rules' are pretty useless.

That's not what I meant when I said to look up *dynamic* pivot. That's a normal pivot, it's got no flexibility to add more columns.

But, something like this...

I don't think it's going to work as you want.

If you're using stored procedures, your procedure should probably be something like:

CREATE PROCEDURE AddClient (<parameter list>)
AS

It's got nothing to do with permissions. Permissions are good, but they're not there to prevent SQL injection.

Your code is not vulnerable to SQL injection because you're parameterising...

Post your code please?

Hold on.

If you start (and hence name) the transaction in the update procedure, there should be no need to check the name, you know the name, because the...

Then why do you need to check the name of the transaction in the update procedure, when you're starting the transaction and committing it in that procedure?

Look up 'dynamic pivot'. It's a way, using dynamic SQL, to do what you want. You need dynamic SQL,  because the number of columns isn't defined at the time of...