Viewing 15 posts - 2,116 through 2,130 (of 22,224 total)
Congrats on the license upgrade. one more level to go.
We aren't Cranky, it's just hard to get people to understand that everything that's new isn't always better or cheaper...
"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 23, 2020 at 1:08 pm
thanks Grant, now I can't CC anyone on an email without feeling guilty (and buying cakes for everyone.)
I used to be cranky, but now i'm the nice DBA who...
"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 23, 2020 at 1:06 pm
I realized not long ago that I’ve spent a good 20 years complaining about how cranky and curmudgeonly SQL DBAs can be. Now I’ve joined their ranks.
Welcome to 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 23, 2020 at 1:05 pm
You have a starting point. There are some primary keys. Heck there are two foreign keys that I saw. So, again, this is largely a paper process to start, spread...
"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 7:19 pm
Agreed. Excellent point.
"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 6:44 pm
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
Viewing 15 posts - 2,116 through 2,130 (of 22,224 total)