Viewing 15 posts - 1,921 through 1,935 (of 22,219 total)
Ah, you've hopped the great Cardinality Estimation Engine gap represented by 2014. Sounds like your system is one of those that has problems with the new CE. Prior to 2014,...
"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 24, 2020 at 1:21 pm
Updating a view isn't updating a join. In fact, I'm not sure how you update a join because you can't. Updating a view is using the fact that a view...
"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 24, 2020 at 12:54 pm
Can you clarify a little what you're looking for here please?
Do you want to compare all the tables in all the databases on a server and find a list of...
"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 24, 2020 at 12:52 pm
Hi Grant,
I am little bit stuck by the word "I/O throughput". Is it something related to data transfer or MB/sec?
Basically, how fast can you read from your disk into...
"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 24, 2020 at 12:05 pm
No, forcing the index just means the optimizer will try to use that index. It doesn't mean it will perform a seek operation. You could use the FORCESEEK hint 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 24, 2020 at 11:58 am
Not a problem. That's what we're here for. Share the 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
February 21, 2020 at 7:45 pm
The thing is, with one exception, I don't see indexing as a way to fix bad parameter sniffing. Indexes cause bad parameter sniffing. The one index I treat as 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
February 21, 2020 at 4:04 pm
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
Viewing 15 posts - 1,921 through 1,935 (of 22,219 total)