Viewing 15 posts - 1,936 through 1,950 (of 22,227 total)
Well, the CHAR(1) can have how many different values if we're not talking the entire ASCII set, 36, alphabet & numbers. The histogram is 200 steps... well, in this case...
"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 21, 2020 at 3:34 pm
are we allowed to post links to "let me google that for you" ? lmgtfy.com š š
I've posted a lot of questions in the last few days relating...
"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 21, 2020 at 2:56 pm
We frequently raffle off Steve's shirts at the Redgate Summit events. I'm sure that will continue. Although, for everyone's comfort, it's a shirt he is not wearing and hasn't worn.
"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 21, 2020 at 2:53 pm
we had to drag info out of the original poster and Grant just googled "in memory open source" - ... i think he might have given up on that...
"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 21, 2020 at 2:03 pm
Have you looked at Pure Storage? They do stuff that seems like magic honestly.
"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 21, 2020 at 12:28 pm
Let's start with the obligatory, it depends.
I wouldn't, myself, describe a covering index as a solution to parameter sniffing. Instead, what a covering index can give you, depending on 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
February 21, 2020 at 12:27 pm
Although, purely technically, just for Steve, aren't they called Friday Shirts? That would invalidate the answers to this question would it not?
"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 21, 2020 at 11:59 am
Beautiful Hawaiian shirts.
"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 21, 2020 at 11:58 am
Here, rather than try to really help, I just googled "open source in memory database". Here you go.
"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 21, 2020 at 10:49 am
For I/O, here are a couple of articles on how to track it and understand it. I'd still recommend getting a copy of the execution plan plus runtime...
"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 21, 2020 at 10:48 am
What he said.
"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 20, 2020 at 6:38 pm
Thanks for all the feedback on this one everyone. Good to hear.
"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 20, 2020 at 6:35 pm
Much less enjoyable are the people who have decided that because Iām an expert, whatever that means, that I have to have all the answers, all 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
February 20, 2020 at 2:32 pm
And, of course, you're 100% correct on what you showed with the compatibility levels.
"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 20, 2020 at 2:32 pm
No, sorry for the confusion. My fault.
I meant take a backup from your 2019 instance and restore it to 2016.
Apologies for stating that poorly.
"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 20, 2020 at 1:39 pm
Viewing 15 posts - 1,936 through 1,950 (of 22,227 total)