Viewing 15 posts - 18,901 through 18,915 (of 22,219 total)
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
Jeff Moden (12/31/2008)
Tom.Thomson (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:03 am
Thanks for the correction. I wasn't sure and I haven't really looked at the table valued parameters yet. I should have kept my mouth shut.
"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 6:57 am
Even though SQL Server 2005/2008 will store excess values past the 8060 limit when dealing with varchar,etc., you will get performance overhead to go and do that extra retrieve. I'd...
"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 6:17 am
Returning 89000 rows out of 100000 pretty much means that you're going to get scans of the table and/or indexes involved.
However, there might be things that can be done. Can...
"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 6:11 am
Assuming it's not a real text file, in which case, it's just a dump of a database and you'll need to get the structure from another source and then use...
"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 6:09 am
I think you can do that in 2008, not that it helps you in 2005.
"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 6:03 am
Putting data into the tempdb is quite a lot different than putting data into an Excel file. I guess I'm still going to need more information here.
I just glanced...
"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 5:57 am
Viewing 15 posts - 18,901 through 18,915 (of 22,219 total)