Viewing 15 posts - 2,251 through 2,265 (of 22,219 total)
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
The information put into the missing index DMVs is taken from the information put into execution plans. So, yes. they are directly correlated.
I strongly recommend you abandon the missing index...
"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:53 pm
A strong suggestion.
Listen to what Lynn has said. Your best bet would be to get someone who knows what they're doing in to teach you. Not to have them do...
"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:21 pm
I suspect that they are someone who is way in over their head, and uses places such as here to "do their job".
Just to be a contrarian, I'm ok...
"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:16 pm
Different Ways to Improve SQL Query Performance
Avoid Multiple Joins in a Single Query. ...
Whoa!
No. Absolutely not. You structure your data as is appropriate with primary keys and enforced referential...
"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:03 pm
Which version of SQL Server are we talking about because CXPACKET waits either mean nothing at all, or are strong indicators of CPU use.
Regardless, if I were you, you know...
"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 11:49 am
Viewing 15 posts - 2,251 through 2,265 (of 22,219 total)