Viewing 15 posts - 19,291 through 19,305 (of 22,219 total)
Jeff Moden (11/22/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
November 23, 2008 at 6:50 am
Jeff Moden (11/22/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
November 23, 2008 at 6:43 am
Jack Corbett (11/22/2008)
Grant Fritchey (11/22/2008)
Terribly late to the party, rude of me, I know.
Better late than never. Oh, and based on your tweets it didn't seem like you were...
"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 22, 2008 at 8:50 am
Hey Jeff,
Just curious, I was thinking about it, and, you know, I was wondering, have you got a good, you know efficient, way to clear a table?
All my love,
Grant
"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 22, 2008 at 8:35 am
Oh, and one more.
On the URGENT posts. My favorites are the ones where you post a possible answer to the question with five minutes of the OP, but you 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
November 22, 2008 at 7:36 am
Terribly late to the party, rude of me, I know.
I agree with Steve, it seems to come in waves. It is a bit shocking that people think that posting 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 22, 2008 at 7:33 am
Congratulations and very well done. That looked like serioulsy tough competition.
"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 22, 2008 at 7:19 am
That was just a typo. Sorry about about the confusion. The script is right and the text is slightly off.
"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, 2008 at 6:59 am
If anyone has a volume 4 laying around, I'd love to get a copy.
"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 16, 2008 at 3:54 am
That's odd. There used to be a link to buy them. I can't find it anywhere. Steve!
"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 14, 2008 at 11:36 am
Last time I tried, the files were locked. You can set up a rollover so that you're getting a new file every so often and the old files are available.
Alternately,...
"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 13, 2008 at 6:33 am
It's also possible that you have different default ANSI settings on the two machines. This could affect performance. A good way to test both would be to use a trace...
"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 12, 2008 at 7:37 am
The first response pointed out a number of issues you have'nt talked about addressing. Query tuning, indexing and all the associated work around those issues can and do lead to...
"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 12, 2008 at 7:02 am
I understand why you might not build constraints in a data warehouse (sort of), but it makes no sense at all to choose not to build indexes. I mean, 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
November 12, 2008 at 6:59 am
Check this article out
"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 12, 2008 at 6:53 am
Viewing 15 posts - 19,291 through 19,305 (of 22,219 total)