Viewing 15 posts - 18,511 through 18,525 (of 22,219 total)
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
Ninja's_RGR'us (2/3/2009)
Grant Fritchey (2/3/2009)
It was good for a giggle.I think a different theme next time. Any Babylon 5 fans?
Not here, how about star trek... any series?
Eh! If I must.
Maybe something...
"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 9:25 am
While waiting for the execution plan (actual, not estimated please), I looked through a bit of the code.
This is going to cause the query to run slow since it has...
"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 9:24 am
It was good for a giggle.
I think a different theme next time. Any Babylon 5 fans?
"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 9:16 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 9:04 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 9:02 am
Can you post the Connect link here please? Others that might run into the problem will want to raise it's importance and anyone else that hits the problem is going...
"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 6:41 am
OK. I was pretty sure of this, but I wanted to verify it. We don't use the Wizard for deployments. Instead we deploy to the file share referenced by 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
February 3, 2009 at 6:31 am
Viewing 15 posts - 18,511 through 18,525 (of 22,219 total)