Viewing 15 posts - 15,511 through 15,525 (of 22,227 total)
WayneS (4/17/2010)
Grant Fritchey (4/17/2010)
WayneS (4/17/2010)
Steve Jones - Editor (4/16/2010)
I almost shudder to post this, but you all might like this:as a sample, let me Google clustered index for you: http://lmgtfy.com/?q=clustered+index
Steve,...
"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
April 17, 2010 at 9:35 am
WayneS (4/17/2010)
Steve Jones - Editor (4/16/2010)
I almost shudder to post this, but you all might like this:as a sample, let me Google clustered index for you: http://lmgtfy.com/?q=clustered+index
Steve, surely you've seen...
"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
April 17, 2010 at 7:26 am
If the queries are starting to take more time, it could be that your statistics are getting out of date. Do you have a maintenance plan for maintaining them? It'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
April 17, 2010 at 3:27 am
Yes, Michael's on top of this. If a SQL Agent Job is actively running, you cannot call it and start it again.
"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
April 17, 2010 at 3:23 am
jabadwy (4/16/2010)
"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
April 17, 2010 at 3:22 am
Microsoft offers a tool called the Upgrade Advisor. You need to track down a copy of this. It's available online. It will walk you through most of the process 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
April 17, 2010 at 3:11 am
Jack Corbett (4/16/2010)
WayneS (4/16/2010)
Jack Corbett (4/16/2010)
I'll be in touch as we are planning our next SQLSaturday now. Early October is a nice time to be here.
Hey Jack, how...
"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
April 16, 2010 at 11:48 pm
Jack Corbett (4/16/2010)
Grant Fritchey (4/16/2010)
dma-669038 (4/16/2010)
Grant Fritchey (4/16/2010)
dma-669038 (4/16/2010)
"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
April 16, 2010 at 3:28 pm
dma-669038 (4/16/2010)
Grant Fritchey (4/16/2010)
dma-669038 (4/16/2010)
"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
April 16, 2010 at 1:19 pm
Ray K (4/16/2010)
Grant Fritchey (4/16/2010)
Me too.
Yep, we had this conversation before. Looking forward to finally meeting...
"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
April 16, 2010 at 1:11 pm
dma-669038 (4/16/2010)
"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
April 16, 2010 at 1:10 pm
Me too.
"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
April 16, 2010 at 12:56 pm
Wayne nailed it. Don't hit the green arrow, despite how tempting it looks.
"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
April 14, 2010 at 2:47 pm
solipeta.veena (4/14/2010)
I have "insert into selectfrom query" in my Stored Procedure, I want to optimize my SP.can u please tell me how to optimize the query.
Bare minimum, you have...
"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
April 14, 2010 at 12:02 pm
CirquedeSQLeil (4/14/2010)
Grant,Which forums to you find to be more informative and useful - SSC or MSDN?
You have to ask?
Joking aside, I like SSC for SQL. But there's more to life...
"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
April 14, 2010 at 10:10 am
Viewing 15 posts - 15,511 through 15,525 (of 22,227 total)