Viewing 15 posts - 2,671 through 2,685 (of 22,219 total)
Great point. I understand what your are seeing about optimizing the query by measuring 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
March 29, 2019 at 4:42 am
Do not upgrade to 2014 if you can absolutely avoid it. The issue is that 2014 introduces a new cardinality estimation engine. However, it doesn't introduce any tools to deal...
"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
March 28, 2019 at 9:55 am
It'll do the job. It's not how I'd do it. I would capture the metrics through extended events. The reason for this is, depending on where you run it 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
March 28, 2019 at 9:02 am
This is not a homework service. We'll help. We won't do all the work. Try it. Tell us where you get stuck. Show your work. We'll help you fix it...
"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
March 27, 2019 at 7:21 am
Without the structure and the execution plan, I'm guessing here.
Yes, if you're trying to squeeze more performance, a covering index may be the way to go. "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood" Author of:
- Theodore Roosevelt
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 27, 2019 at 7:20 am
An old-school, and effectively free, solution to this is setting up log shipping. However, that has received almost no love from Microsoft for years. The preferred method as was already...
"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
March 27, 2019 at 7:13 am
GilaMonster - Monday, April 13, 2015 2:30 AMA good backup.
Yep. A tested backup strategy is your single best means of recovery, without...
"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
March 26, 2019 at 7:35 am
We're starting from a fundamental problem in the premise:
Can anyone explain why, when selecting data into a CTE and then using the results in the CTE 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
March 26, 2019 at 7:31 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
March 22, 2019 at 12:46 pm
Strong, strong recommendation. Start learning notebooks. Also containers.
This message is actually most of the MVP Summit this year. Unlike other years, it's not a marketing message. This is...
"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
March 22, 2019 at 12:14 pm
"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
March 15, 2019 at 9:32 am
The title says SSMS and the text says SQL Server. So, which is it? Are you trying to connect to SQL Server 2016 from SSMS 2012? If so, yeah, 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
March 13, 2019 at 7:38 am
Funny enough, that's one of my phone screen questions. I'd say anyone that has to do more than consume data from SQL Server really has to know this. It's one...
"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
March 13, 2019 at 7:22 am
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
March 13, 2019 at 5:58 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
March 13, 2019 at 5:11 am
Viewing 15 posts - 2,671 through 2,685 (of 22,219 total)