Viewing 15 posts - 2,731 through 2,745 (of 22,224 total)
"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 8, 2019 at 12:25 pm
Is there a measurement that can be taken on such things to determine...
"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 8, 2019 at 11:53 am
You are going to want to rebuild columnstore indexes on some sort of basis. This does two things. It helps to condense the columns down so that the compression works...
"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 8, 2019 at 6:47 am
Hey Jeff!
Do you lend out the launcher to family & friends? If so, you've given it to the wrong person. If not, dude, go check on it, because I...
"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 8, 2019 at 5:53 am
Ah, yeah, if the Query Store is read only, it sure won't be collecting data. I'm still going to test what happens when the database itself is read only. I...
"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 7, 2019 at 5:33 am
The database is Read Only?
Hmmm. I haven't tested that. I'll get on it. Thanks for the blog post idea.
Now, what are all the Query Store settings?...
"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 7, 2019 at 4:54 am
"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 7, 2019 at 4:19 am
"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 6, 2019 at 6:22 am
Please, don't upgrade anything to 2014. It's not that 2014 is bad. It's not. It's that 2014 introduced a potential problem and didn't supply good tools to deal with 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 6, 2019 at 5:47 am
I need advice. I have almost 30 Update statements with different logic in...
"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 6, 2019 at 5:36 am
"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 5, 2019 at 7:36 am
"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 5, 2019 at 6:47 am
So... all those REPLACE things are going to prevent statistics use and index use and you're going to see degraded performance. Whatever structure is in place that forces that upon...
"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 5, 2019 at 5:53 am
There are a bunch of articles right here on SQL Server Central that can help to get you started. This one right here seems perfect. Do a search...
"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 5, 2019 at 5:50 am
I don't know of a complete course on this. I have several videos on my Youtube channel. I'll probably record more, but I doubt I'll ever do enough...
"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 5, 2019 at 5:44 am
Viewing 15 posts - 2,731 through 2,745 (of 22,224 total)