Viewing 15 posts - 2,731 through 2,745 (of 22,219 total)
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
"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:09 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 1, 2019 at 6:59 am
Ed Wagner - Thursday, January 31, 2019 12:49 PMExactly. You hit the nail on the head. 😉
Seriously? They lost five...
"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 31, 2019 at 1:30 pm
Sounds like Rob Volk's awesome presentation, Revenge, The SQL.
Anyway, you need brackets on your database names in the code. It'll have to go into 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 31, 2019 at 7:05 am
The DDL triggers are a great idea (although I don't use SSIS and...
"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, 2019 at 6:34 am
Viewing 15 posts - 2,731 through 2,745 (of 22,219 total)