Viewing 15 posts - 2,116 through 2,130 (of 22,219 total)
I'll be the angel of death this time:
https://www.bbc.com/news/entertainment-arts-51209197
I'd love to say, he's not quite dead.
"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
January 22, 2020 at 12:52 pm
Yep. Sorry. Totally got that wrong. I must have been thinking of telnet. Apologies.
"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
January 22, 2020 at 12:50 pm
Wow. You're in a tough spot. There is a very high likelihood that the business also doesn't know how these tables match. Personally, I'd suggest you bring some tooling into...
"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
January 22, 2020 at 12:49 pm
What was the name of the book with a "fascinating history about Audrey Hepburn?"
"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
January 21, 2020 at 9:18 pm
Thanks for the feedback @rod at work. I've pulled back from some online communities because of the negativity. Life is far too short and painful on it's own to intentionally...
"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
January 21, 2020 at 6:17 pm
his response "we're so used to it breaking we've stopped complaining" - these are really valuable unknowns that we need to start knowing. my personal opinion is that getting...
"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
January 21, 2020 at 6:14 pm
Yep. Another vote for ping. If you can't see it in your network, you can't connect to it. Also, when you ping, be sure to specify a port number that...
"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
January 21, 2020 at 2:32 pm
I will also reinforce your backup and restore example. Sometimes system people drive me nuts when they say the whole server is backed up. That doesn't necessarily protect the...
"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
January 21, 2020 at 2:27 pm
I think we're back to the original suggestion from Eirikur, an index on your temp tables to assist in filtering that data. The one table #repositioning, says it has 1...
"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
January 21, 2020 at 1:42 pm
Sounds like a great methodology. Well done.
"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
January 21, 2020 at 1:19 pm
And, deadlocks are fundamentally a performance tuning issue, so look at the exec plan to be sure there are no tuning opportunities. Then, determine what the deadlocks are exactly from...
"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
January 19, 2020 at 6:41 pm
I can't say without knowing it's actually hitting deadlocks. Then, it's about the deadlocks encountered. Sorry, no way to know what that is from where I'm sitting.
"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
January 19, 2020 at 1:50 pm
They're all different and do different things. I'd suggest reading up on all of them and then comparing them to your needs. Just saying DDL & DML isn't sufficient to...
"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
January 18, 2020 at 3:25 pm
Don't mistake my comments. XE is very well documented. Just not all the events. However, the events that most people are going to use, especially around auditing, are well documented.
I...
"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
January 18, 2020 at 1:41 pm
This would all output to an XML file. You can query it using SSMS or load it into a table using extended stored procs and XQuery.
...which is why...
"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
January 17, 2020 at 11:16 pm
Viewing 15 posts - 2,116 through 2,130 (of 22,219 total)