Viewing 15 posts - 18,901 through 18,915 (of 22,226 total)
I just repeated your tests and did not get your results.
Just a guess, did you highlight it exactly the same way both times? Meaning, including carriage return and line feeds...
"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
January 2, 2009 at 9:58 am
I may as well be the dissenting opinion.
It depends on the complexity of the joins. When we're talking about simple, say fewer than 15 or so, tables joined together,...
"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
January 2, 2009 at 8:46 am
There is less disparity between the estimated & the actual, so that's good. You've still got a missing JOIN predicate. That should get fixed.
I still suggest you run UPDATE STATISTICS...
"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
January 2, 2009 at 8:41 am
Maybe a change to the connection settings? This will cause a new plan to be compiled.
"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
January 2, 2009 at 7:30 am
At least show what you've tried that hasn't worked.
"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
January 2, 2009 at 7:22 am
AndyG (1/2/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
January 2, 2009 at 6:46 am
wagner crivelini (1/2/2009)
When I wrote this article I had in mind that not all T-SQL beginner are completely unaware...
"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
January 2, 2009 at 6:34 am
It has to be a "nice to have." Most of the time, your statement of "data is data is data" is just too true. My experience has been reasonably wide...
"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
January 2, 2009 at 6:29 am
First things first, do you have automatic statistics enabled on the database? If not, why not?
The index IX_VarOffice is showing as 1 estimated row and 84,000 actual rows. That's usually...
"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
January 2, 2009 at 6:20 am
I like the article. Showing common cursor practices and a nice set-based approach to replace them is absolutely the right way to go. Unfortunately, as Jeff already pointed out, you...
"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
January 2, 2009 at 6:08 am
Manie Verster (1/2/2009)
RBarryYoung (1/1/2009)
I can't imagine why? "Challenge" doesn't imply that anyone is going to reply anytime soon.Maybe "Puzzles & Challenges"?
Sounds like a good idea. I just think 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
January 2, 2009 at 5:43 am
I was just reading a blog post by Hugo Kornelis. He said, based on his tests, STATIC was the way to go, that it outperformed FASTFORWARD cursors.
"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
December 31, 2008 at 8:31 am
Are you kidding? I write cursors for everything so that I can come back later and "tune" the query.
"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
December 31, 2008 at 7:54 am
Jeff Moden (12/31/2008)
Grant Fritchey (12/31/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
December 31, 2008 at 7:23 am
I presented this as a database design at a meeting once.
CREATE TABLE [dbo].[AppTable](
[Id] [int] IDENTITY(1,1) NOT NULL,
[RefId] [int] NOT NULL,
[AppValue] [nvarchar](max) NOT NULL,
CONSTRAINT [PK_AppTable] PRIMARY KEY CLUSTERED
(
[Id] ASC
)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
December 31, 2008 at 7:21 am
Viewing 15 posts - 18,901 through 18,915 (of 22,226 total)