Viewing 15 posts - 14,341 through 14,355 (of 22,219 total)
What about making it into a stored procedure and then making the call to that? That would absolutely fix the issue.
"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 20, 2010 at 9:09 am
GilaMonster (9/20/2010)
*trumpet crescendo*
... and I think I'll leave things here for a little while.
Edit: And as soon as i decide not to post for a few hours, there's 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 20, 2010 at 6:13 am
The Dixie Flatline (9/16/2010)
ALZDBA (9/16/2010)
CirquedeSQLeil (9/16/2010)
BTW - at the pace you guys are on with this thread - 20K should be easy peezy lemon squeezy.21k may be attainable 😎
A single...
"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 16, 2010 at 1:18 pm
Another positive vote. I love these things.
"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 16, 2010 at 9:12 am
GilaMonster (9/16/2010)
WayneS (9/16/2010)
But Gail, you know that there are so many other people that truly appreciate you. Just ignore the ID 10 T's and help those that appreciate it.
Yeah. Still...
"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 16, 2010 at 8:12 am
Tom.Thomson (9/15/2010)
Stefan Krzywicki (9/14/2010)
CirquedeSQLeil (9/14/2010)
Alvin Ramard (9/14/2010)
GilaMonster (9/14/2010)
Grant Fritchey (9/14/2010)
GilaMonster (9/14/2010)
Lynn Pettis (9/14/2010)
A) Admit when you are wrong.
B) 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 15, 2010 at 12:46 pm
GilaMonster (9/14/2010)
Lynn Pettis (9/14/2010)
The key to arguing with GilaMonster (or anyone for that matter) is:A) Admit when you are wrong.
B) If not A, agree to disagree.
And
C) If you're right, don't...
"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 14, 2010 at 12:12 pm
Assuming there's no stress on the system, running a procedure to rebuild/reorganize the indexes once a day, based on the level of fragmentation & number of pages, is fine. We've...
"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 14, 2010 at 11:33 am
ALZDBA (9/14/2010)
GilaMonster (9/14/2010)
Grant Fritchey (9/14/2010)
The Dixie Flatline (9/14/2010)
There are two types of people in the world. Those who can see what's coming next.And...
And you're obviously one 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 14, 2010 at 7:49 am
The Dixie Flatline (9/14/2010)
There are two types of people in the world. Those who can see what's coming next.
And...
We're waiting.
"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 14, 2010 at 7:35 am
Rebuilding the indexes should have also rebuilt the statistics, so I wouldn't necessarily assume that's where the problem lies. Without seeing the queries & execution plans it's hard to know...
"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 14, 2010 at 6:28 am
coolwebs (9/13/2010)
SELECT usecounts,
cacheobjtype,
...
"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 13, 2010 at 1:05 pm
I agree with the ANSI settings. That can result in different execution plans for the same procedure. But, you might also be seeing parameter sniffing. Are all the apps running...
"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 13, 2010 at 12:46 pm
Blanket statements are usually worthless, so with that in mind...
I'd suggest, at a minimum, making the PK's clustered instead of non-clustered. Probably they're the best access path to the data...
"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 13, 2010 at 12:43 pm
I think in this case it would be "with friends like these, who needs anchors." Works at about the same I imagine.
"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 12, 2010 at 7:22 pm
Viewing 15 posts - 14,341 through 14,355 (of 22,219 total)