Viewing 15 posts - 19,801 through 19,815 (of 22,219 total)
First, and most important, before you worry about a tool, you need to focus on your process. Discipline around how and when you deploy is more important than the tool...
"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
August 7, 2008 at 6:21 am
More than a few of us on are Linked-In. It is like Gail said though, I would only recommend someone after a pretty long relationship that involves more than 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
August 7, 2008 at 6:14 am
You may need to post your code because that should work fine. As one of the previous posts said, you may have your PK improperly defined.
"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
August 7, 2008 at 6:10 am
It sure makes the editorial I just read in SQL Server Magazine sound a little weird. He mentions the release "later this year" of 2008. I thought it sounded strange...
"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
August 7, 2008 at 5:32 am
Thanks for all the responses.
I got one yesterday, I think it was maybe the third one I've received over the years (I'm hardly one of the "go-to" guys). It was...
"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
August 7, 2008 at 5:27 am
Cool. Thanks for sharing.
"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
August 6, 2008 at 1:32 pm
Everything the other guys said is 100% accurate, but one other note, you may want to take into account.... With really simple queries like the ones you showed, the optimizer...
"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
August 6, 2008 at 11:06 am
I agree with GSquared. Both enabled, everywhere. Also a script that checks indexes and then does a rebuild or reindex based on fragmentation. Also, there is the occasional index or...
"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
August 6, 2008 at 11:02 am
Or go up to the Search window just about here and type in TSQL and "SQL Server 2008" or "SQL Server 2005." You can filter by article then. There are...
"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
August 6, 2008 at 11:00 am
Last I heard, they were still releasing in August. I haven't seen any definite release dates, but I haven't seen anything that said it was slipping.
Here's a post from...
"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
August 6, 2008 at 10:56 am
Unwise, poorly worded, incomplete, untested, filled with mistakes, rebuttal!
"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
August 6, 2008 at 6:01 am
Oooh, that's a lovely one Steve. There's a product to stay away from.
I'll bet these are the very same developers that are in full-throated howl against using stored procs...
"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
August 6, 2008 at 5:50 am
That's a pretty standard approach. Not necessarily the most accurate since you're only capturing what's different, not specifically what needs to be moved. At some point, depending on your development...
"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
August 2, 2008 at 3:06 pm
Marios Philippopoulos (8/2/2008)
Grant Fritchey (8/2/2008)
"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
August 2, 2008 at 11:15 am
It heppens to us all. That second set of eyes can work wonders sometimes.
"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
August 2, 2008 at 11:13 am
Viewing 15 posts - 19,801 through 19,815 (of 22,219 total)