Viewing 15 posts - 5,611 through 5,625 (of 22,226 total)
Lord Lucan (9/2/2015)
Grant- no worries, I have much to learn about...
"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
September 2, 2015 at 3:23 pm
Based on the general suggestions you're making, no. What you're suggesting is referred to as Nested Views. It's a common code smell that leads to quite a few problems. 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
September 2, 2015 at 10:59 am
arr.nagaraj (9/2/2015)
The idea struck me when I wanted to read the blogs /articles , stairway series via mobile while I was travelling. Doesn't that sound appealing?;-)
Forums are best suited for...
"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
September 2, 2015 at 10:42 am
sqlfriends (9/2/2015)
That is good to know, so I can do another log backup after the previous diffential, and can still restored to 3:10?That really helps.
Yes. Differentials are tied 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
September 2, 2015 at 10:41 am
Lord Lucan (9/2/2015)
Thanks for the welcome folks.Grant - You've lost me with your second reply 🙂
Lord Lucan. The Charge of the Light Brigade. The battle of Balaclava. The Crimean War....
"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
September 2, 2015 at 10:38 am
ZZartin (9/2/2015)
David.Poole (9/2/2015)
"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
September 2, 2015 at 8:32 am
I have no control over this, but I'd beg Steve to not suggest it. Keep the Redgate programmers working on what they're working on.
"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
September 2, 2015 at 7:15 am
Oh, and please, attack the Heights, not the guns.
"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
September 2, 2015 at 7:14 am
Welcome to the party.
Sounds like you're doing well and learning as you go. Reading the articles here will help. A strong suggestion, read the questions and try to answer some....
"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
September 2, 2015 at 7:10 am
I would focus on using PowerShell. You can make the call to the procedure, capture the output to file. It's the most direct mechanism available. You'll have maximum control 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
September 2, 2015 at 7:05 am
If you add the next log backup, you should be able to get to 3:10.
"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
September 2, 2015 at 5:29 am
Assuming you changed the compatibility setting on your database so that it's now at 120, you're using the new cardinality estimator that comes with SQL Server 2014.
Queries that were marginal...
"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
September 2, 2015 at 5:26 am
sunnyepgc (9/2/2015)
"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
September 2, 2015 at 5:22 am
The biggest difference between 2008 & 2014 was the new cardinality estimator. First off, make sure the database compatibility mode is set to 120. If it is, you're using 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
September 1, 2015 at 8:22 pm
Better to use Extended Events, but yeah, both have a recompile event that you can observe.
"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
September 1, 2015 at 12:22 pm
Viewing 15 posts - 5,611 through 5,625 (of 22,226 total)