Viewing 15 posts - 2,026 through 2,040 (of 22,232 total)
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
Ah well.
"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 6:36 am
Nature of the beast. You'll have to love when the DBA is expected to also be a master in 5 different programming languages, 6 different operating systems, relational data, non-relational...
"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 2, 2020 at 6:51 am
I'd bet back around to it. Knowing, through valid and successful tests, that you can restore your individual databases per the business RTO & RPO is the only way 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
February 2, 2020 at 6:49 am
A CTE is essentially just a materialised view of the data set, so it points to the actual underlying objects used.
This is what I suspected. When you say...
"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 1, 2020 at 11:16 am
When the business overrides you, there really isn't much you can do. Education is key. However, I'm still very much on the side of being part of the team rather...
"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 31, 2020 at 10:17 pm
Very much mirrors my experience. Once people know how things work, the actual labor to make it work is pretty simple.
"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 31, 2020 at 10:14 pm
A lot of developers are not at all familiar with managing their own instances. This is more of a problem with Oracle where it's not as easy to restore...
"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 31, 2020 at 3:44 pm
Viewing 15 posts - 2,026 through 2,040 (of 22,232 total)