Viewing 15 posts - 1,066 through 1,080 (of 49,552 total)
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 24, 2017 at 11:39 am
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 24, 2017 at 7:09 am
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 24, 2017 at 6:45 am
What do you want help with?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 24, 2017 at 6:13 am
No. it's not. See the blog post I referenced.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 24, 2017 at 5:25 am
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....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 24, 2017 at 5:22 am
Please note: 7 year old thread.
And those 'rules' are pretty useless.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 24, 2017 at 5:19 am
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 24, 2017 at 12:59 am
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 23, 2017 at 4:24 pm
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>) Gail Shaw
AS
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We stand on the bridge and no one may pass
July 23, 2017 at 3:33 pm
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 23, 2017 at 2:10 pm
Post your code please?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 23, 2017 at 1:45 pm
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 23, 2017 at 1:24 pm
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 23, 2017 at 1:01 pm
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 23, 2017 at 10:59 am
Viewing 15 posts - 1,066 through 1,080 (of 49,552 total)