Viewing 15 posts - 2,056 through 2,070 (of 22,219 total)
Also, thinking on this, are you saying that the query and the view are the same, but the view is slower? Or are you saying that you wrote a query...
"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 29, 2020 at 1:42 pm
Yep, execution plan.
Also, grouping by a function means poor, or no, index use. Calculated column with an index could help.
Still, execution plan.
"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 29, 2020 at 12:30 pm
Just a caution. Partitioning is great for data management. Partitioning is horrible for performance. It only enhances performance when you see a near perfect ability of your code to always...
"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 29, 2020 at 12:27 pm
I never argue on these things. I just ask them to demonstrate a point in time restore that meets both our business defined Recovery Point Objective and Recovery Time Objective....
"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 29, 2020 at 12:25 pm
The documentation doesn't mention 'rt' at all, only 'r' and 'rb': https://docs.python.org/3/tutorial/inputoutput.html#reading-and-writing-files
Did some research, 't', text, is the default, so you don't HAVE to have it. But, on...
"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 29, 2020 at 12:22 pm
Wild stab in the dark for the win!
"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 29, 2020 at 12:18 pm
as long as I can use scalar value function inlining and the new table variable cardinality estimation then i'm happy
Hmmmm, I haven't tested it, but it's possible that 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 29, 2020 at 12:09 pm
Probably. This isn't azure, but Microsoft pays a lot of attention to anything azure, so, it'll work.
"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 29, 2020 at 11:51 am
would using 2019 compatability mode, but setting the "legacy cardanility" option on be a wise idea?
After extensive testing, yes, maybe, depending on the outcome of the tests.
"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 29, 2020 at 11:42 am
Sounds like it's CPU bound then. One or more of the processes is hung on CPU. Again, break down what you're doing and determine which process is stuck.
"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 28, 2020 at 3:29 pm
Me too. I got the question right through the process of elimination, not knowledge.
"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 28, 2020 at 2:33 pm
There are many different scheduling services within Azure. Find one of them and put it to work.
"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 28, 2020 at 1:39 pm
Filtering on your extended events would be the biggest boost. Don't capture what you don't need. Most stringent filters first in order (maximizes the reduction in overhead).
"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 28, 2020 at 1:38 pm
If it has gone from minutes to days, that is highly abnormal. I'd suggest stopping that process. Disable it for the moment. Then, I would run each of the "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood" Author of:
- Theodore Roosevelt
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 28, 2020 at 1:36 pm
There. Cleared it up.
"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 28, 2020 at 1:22 pm
Viewing 15 posts - 2,056 through 2,070 (of 22,219 total)