Viewing 15 posts - 2,056 through 2,070 (of 22,224 total)
My apologies. I wanted to Quote Jeff's answer, but accidentally hit the REPORT link instead. Are Admins/Mods able to please undo my error
This was the post (copied from my...
"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 30, 2020 at 8:52 am
I would like to defend myself, just a little. I didn't say surrender completely. I said, surrender, just a little. A lot of our peers see our rants about idiot...
"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 30, 2020 at 8:50 am
Along with what Grant has stated and since they said it did "regular" SQL Backups, have them do a test restore using native tools only to prove it's a...
"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 30, 2020 at 8:44 am
Just a thought,
every post I've replied to in the last few weeks has had updates and new info from pretty much the same bunch of people on here.
Grant, Jeff,KTFlash,...
"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 6:33 pm
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...
"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 2:13 pm
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
Viewing 15 posts - 2,056 through 2,070 (of 22,224 total)