Viewing 15 posts - 18,511 through 18,525 (of 22,226 total)
Is it possible that the different connections are changing the ANSI settings? That's the only thing that comes immediately to mind.
"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
February 4, 2009 at 6:53 am
For a bare-bones introduction to backups, check this out[/url].
"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
February 4, 2009 at 6:36 am
Huh. This sure sounds like what Profiler provides:
What is Code Coverage?
Code coverage measurement simply determines those statements in a body of code have been executed through a test run 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
February 4, 2009 at 6:30 am
Christopher Stobbs (2/4/2009)
HI Grant,How do I check this: "You still need to look at I/O, CPU, execution time, wait states... " for the different operations in the query plan?
Basically turn...
"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
February 4, 2009 at 5:25 am
idrees.butt (2/3/2009)
"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
February 3, 2009 at 1:37 pm
Steve Jones - Editor (2/3/2009)
a gee-whiz fiber optic laser beam assembler?:D
Standard model. She Who Must Be Obeyed makes me cut corners.
"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
February 3, 2009 at 1:34 pm
jungnaja (2/3/2009)
"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
February 3, 2009 at 1:31 pm
I'd start with Itzik's book. It'll get you going. As you've seen, there's tons more out there, but you have to start somewhere.
"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
February 3, 2009 at 1:21 pm
And apparently I'm no longer able to work the link buttony thing... If only it were a fiber optic laser beam assembler... I'd be fine.
"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
February 3, 2009 at 1:18 pm
Lynn Pettis (2/3/2009)
GilaMonster (2/3/2009)
Bruce W Cassidy (2/3/2009)
I'm still struggling with reading most of the questions. I think it's because I'm such a noob.
Nah. You're not the only one. That's...
"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
February 3, 2009 at 1:02 pm
Backups, first, last & always. You can't be paranoid enough.
Also, are your databases in simple recovery mode or full? If full, you need to come up with a log backup...
"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
February 3, 2009 at 10:53 am
GilaMonster (2/3/2009)
Grant Fritchey (2/3/2009)
Any Babylon 5 fans?Entil'zha Veni. In Valen's Name!
We live for the one. We die for the one.
HA! Ya'll are in trouble now.
"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
February 3, 2009 at 10:48 am
Christopher Stobbs (2/3/2009)
"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
February 3, 2009 at 10:36 am
twdavis (2/3/2009)
execution plan add in attachments
First thing I see is several key lookups on the PS_IN_DEMAND table to get QTY_REQUESTED_BASE & QTY_BACKORDER_BASE columns. You could add these as an INCLUDE...
"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
February 3, 2009 at 10:34 am
GilaMonster (2/3/2009)
Grant Fritchey (2/3/2009)
"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
February 3, 2009 at 10:18 am
Viewing 15 posts - 18,511 through 18,525 (of 22,226 total)