Viewing 15 posts - 2,251 through 2,265 (of 22,224 total)
You could set up your firewall (and please, tell me you have one) so that it only allows connections from specific IP addresses or IP address ranges, that would make...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 12, 2019 at 1:40 pm
Oh yeah, I'm not complaining that people don't use it EVERYWHERE. I'm complaining that people don't use it, even in places where it would offer a clear advantage.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 11, 2019 at 8:34 pm
If the exec plans are the same, it's got to be a difference elsewhere. Database settings (probably not since this is a restore), server settings, os settings, vm settings. Something...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 11, 2019 at 1:50 pm
Under most circumstances, not getting into data skew, bad column choices, etc.
Yeah.
In fact, having an index on C1 or an index on C1 and C2 as keys would be effective...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 11, 2019 at 1:47 pm
I don't have specific data, but I think it's the same reason that people are shy about using Extended Events.
In 2008, Extended Events were introduced, but, weren't quite functional. In...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 11, 2019 at 12:46 pm
Yeah, I am ancient. I'd still pick SQLCMD or PowerShell over bcp though.
Heh... guess I'm more ancient. I've not found much that will actually beat BCP...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 11, 2019 at 12:36 pm
Yeah, I am ancient. I'd still pick SQLCMD or PowerShell over bcp though.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 10, 2019 at 3:17 pm
If you can't reset to capture the older plans, you're stuck. Code modification is the best way to go. You could also look to plan guides to supply the hint.
Most...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 10, 2019 at 3:14 pm
If you're really looking to automate and control this, SSIS is the magic place for data movement within SQL Server.
However, if you want to stick to a command line driven...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 10, 2019 at 2:38 pm
I assume you jumped from below SQL Server 2014 to SQL Server 2017?
Your best bet would be to change the compatibility mode back to the old compatibility so that SQL...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 10, 2019 at 2:31 pm
2012 supports causality tracking right? I'd add that to the extended event so you can see these things grouped.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 10, 2019 at 3:11 am
As long as you're all going for "jobs like mine" and not my job. I'm not done with it yet.
As to pay cuts. A long time ago (and let's hope...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 9, 2019 at 3:56 pm
Thanks everyone. Forgive me if I have asked too much or hurt anyone.
No, please. Ask away. It's just so clear that you're over your head and suffering. We're trying...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 9, 2019 at 3:14 pm
Not a problem. We're all here to help out when and where we can.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 9, 2019 at 1:12 pm
For the Monitor to stop monitoring you have to be stopping the service. That shouldn't be dependent on you logging in. Are you sure that things are actually running? You...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 9, 2019 at 12:56 pm
Viewing 15 posts - 2,251 through 2,265 (of 22,224 total)