Viewing 15 posts - 2,056 through 2,070 (of 22,227 total)
Nuts! I wasn't paying attention.
"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 9:21 am
What about wait statistics? Have you compared before and after there to see if it gives you a clue as to what's up?
As to Extended Events. They're not terribly difficult...
"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 9:12 am
To add to what Grant has stated, I agree that "new" voices are a bonus on any forum but I have seen some "new" people come in with some...
"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:56 am
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
Viewing 15 posts - 2,056 through 2,070 (of 22,227 total)