Viewing 15 posts - 5,596 through 5,610 (of 22,219 total)
I'm with Luis. The money data type seems attractive, but it just leads to headaches. Use decimals and keep going.
The only issue around that from a data standpoint 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
September 3, 2015 at 6:53 am
It's going to generate an error, but you can use sys.dm_sql_referenced_entities to look at the objects referenced by a given stored procedure. It will at least allow you the ability...
"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 3, 2015 at 6:50 am
SQL Server will take every single gb of memory that you assign it. It won't release that memory unless forced. It's very normal for servers to run with high memory...
"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 3, 2015 at 5:04 am
sqlfriends (9/2/2015)
I thought we will always need a full...
"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:56 pm
Jeff Moden (9/2/2015)
Grant Fritchey (9/2/2015)
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...
"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:16 pm
Eric M Russell (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 3:29 pm
Yeah, that a was kind of badly worded statement. Apologies.
What I meant was, treat every query as a separate entity rather than try to use what looks like, from 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
September 2, 2015 at 3:28 pm
souLTower (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 3:25 pm
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
Viewing 15 posts - 5,596 through 5,610 (of 22,219 total)