Viewing 15 posts - 11,641 through 11,655 (of 22,219 total)
bridgt01 (11/20/2011)
As for updating stats, stats have been updated and indexes 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
November 21, 2011 at 3:57 am
I've been working with Red Gate tools for 10 years now. I've been working for the company for the last nine months. I liked their software so much I went...
"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
November 21, 2011 at 3:47 am
Try getting the execution plan when it's slow and when it's fast. Compare the two. It could be bad parameter sniffing.
But to be honest, it sounds like contention. 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
November 20, 2011 at 6:00 am
ggpevans (11/19/2011)
The two topics are
a) Relationships
b) Joins (Inner joins and cross joins etc)
I understand 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
November 20, 2011 at 5:58 am
Sounds like some seriously large queries and/or some processing occurring within queries that is excessively large. Based on what you've provided, it's hard to say what. I'd suggest setting up...
"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
November 19, 2011 at 10:45 am
And for those interested, you can run an upgrade directly from CTP3.
"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
November 19, 2011 at 5:58 am
So you have a WHERE clause against a 30,000 row multi-statement table valued function... To quote a famous man "Well there's your problem.[/url]"
Seriously though, you may have any number...
"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
November 18, 2011 at 4:02 pm
WayneS (11/18/2011)
Congrats Grant for making the Top 10 Community Choice Bloggers list! Keep up the good work!
Thanks.
I had no idea I was doing good work.
"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
November 18, 2011 at 2:11 pm
WayneS (11/18/2011)
:w00t::w00t::w00t:Just passed 70-451. Now I have all exam pre-req's for 88-970 done... just not sure I'm ready for that one yet though.
Well done.
"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
November 18, 2011 at 11:54 am
Ninja's_RGR'us (11/18/2011)
Steve Jones - SSC Editor (11/18/2011)
Grant Fritchey (11/18/2011)
My title is Product Evangelist, but my job is Booth Babe.Babe, bouncer, or barbarian?
In that kilt?
yes!
Exactly.
"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
November 18, 2011 at 8:54 am
Daryl AZ (11/18/2011)
I was questioning whether switching from a clustered index on an Identity to a clustered index on non-sequential keys would affect...
"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
November 18, 2011 at 8:53 am
I would strongly recommend having a clustered index on the table. It doesn't have to be the primary key, but by and large, in most circumstances, a table with 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
November 18, 2011 at 8:40 am
Gianluca Sartori (11/18/2011)
Grant Fritchey (11/18/2011)
Gianluca Sartori (11/18/2011)
The technique described there uses DBCC commands,...
"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
November 18, 2011 at 7:19 am
Gianluca Sartori (11/18/2011)
The technique described there uses DBCC commands, but it works with...
"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
November 18, 2011 at 6:27 am
That's just so open-ended... How are you at query tuning? Are you an SSIS expert? What about hardware, do much with hardware? Networking? Virtuals? SANs? Performance Monitoring? Operating Systems? 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
November 18, 2011 at 6:24 am
Viewing 15 posts - 11,641 through 11,655 (of 22,219 total)