Viewing 15 posts - 2,011 through 2,025 (of 22,224 total)
Thanks. This is a tough lesson to keep in mind. I forget it from time to time, even at Redgate.
"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
February 9, 2020 at 1:23 pm
I really should read these more closely. I may even get some right.
"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
February 7, 2020 at 11:48 am
oops.
"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
February 6, 2020 at 9:07 am
A thousand likes on this editorial, Grant! WOW, I've never heard of juice jacking or the rest of it. In this case, ignorance although it may be bliss, it...
"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
February 5, 2020 at 3:17 pm
Thanks for that posting - it was a good reminder that we have to be more cautious and less trusting when traveling. I'd like to thing everyone is as...
"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
February 5, 2020 at 3:15 pm
If you were posting it to the water cooler, I think it's fine. Posting it to the forums could very easily be interpreted as spam (not by me, but by...
"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
February 5, 2020 at 10:24 am
Since you're not telling a declarative language exactly what you want it to do, you're counting on a behavior that you simply can't count on. I get it that it...
"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
February 5, 2020 at 9:59 am
Oops. Sorry.
Still don't see an issue with this. If you don't specify exactly what you want, you get whatever the optimizer and the query engine gives you. I wouldn't call...
"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
February 5, 2020 at 9:40 am
This isn't what I'd call a change in behavior. It's always been stated, for decades now, that you can't rely on the order of rows without an ORDER BY statement....
"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
February 5, 2020 at 9:19 am
I would be looking for blocking chains first. That's the most likely scenario. A single query is blocking all the other queries which are waiting on it to complete. There...
"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
February 5, 2020 at 9:15 am
Don't do #3. Down that path lies tons and tons of pain.
Yes, if you do #1 or #2 (and I lean heavily to the first option, the developers work locally...
"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
February 5, 2020 at 9:11 am
So nice to still remember how R works after not touching it for a year.
"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
February 5, 2020 at 8:56 am
The thing is, most people have a spare tire (or at least a donut). Most people have insurance. It's possible to communicate risk and get people to take a reasoned...
"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
February 4, 2020 at 9:41 am
It might be unfair that I got this one right.
"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
February 4, 2020 at 6:35 am
I'm not sure I agree on this one - cooperation leads to learning. rather than fight them we can mentor them
^^^^^^^^^^^^^^^^
YES!!!!
"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
February 3, 2020 at 10:42 am
Viewing 15 posts - 2,011 through 2,025 (of 22,224 total)