Viewing 15 posts - 2,671 through 2,685 (of 22,224 total)
These things spin up and shut down so fast that they don’t exist long enough to hack even if they contained something to hack and for most apps they...
"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
April 1, 2019 at 6:47 am
If you truly need 5 9s of up time, the hardware is still out there and available. I was talking to someone last week who had the need for 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
April 1, 2019 at 6:46 am
What problem are you trying to solve? It's very hard to understand which solution is better when we don't have a clue what problem the solution is solving.
"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 5:37 am
I work for Redgate, so I'm VERY biased, however...
I agree with @crow1969. It's not the exact solution you're looking for. It only catches certain code smells, but 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 29, 2019 at 5:35 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 29, 2019 at 4:43 am
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
Viewing 15 posts - 2,671 through 2,685 (of 22,224 total)