Viewing 15 posts - 5,596 through 5,610 (of 22,226 total)
jasona.work (9/3/2015)
Just make sure you read "The Thread" from beginning to end...There will be a quiz.
:hehe:
No. Don't do 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
September 3, 2015 at 10:25 am
bwhiteside (9/3/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 3, 2015 at 10:24 am
Eric M Russell (9/3/2015)
bwhiteside (9/3/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 3, 2015 at 10:23 am
SQL!$@w$0ME (9/3/2015)
Thanks Raj. File stream is not enabled. Also there are no ssis packages or other applications installed.
You're saying that the SQL Server executable is using more memory than you...
"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 7:00 am
RonKyle (9/3/2015)
Not to sound harsh, but have you ever done any real, complex database development work? It certainly sounds like you haven't.
I have done real, complex database development, both 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
September 3, 2015 at 6:59 am
There currently is no good way to handle this within SQL Server. Copy & paste is how most people do it. Now, you can make this work better, especially if...
"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:56 am
Another vote for using Jeff's tally table method. It's going to work so much better.
"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:54 am
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
Viewing 15 posts - 5,596 through 5,610 (of 22,226 total)