Viewing 15 posts - 14,476 through 14,490 (of 22,224 total)
Alvin Ramard (8/17/2010)
"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 17, 2010 at 10:17 am
One more vote for Itzik Ben-Gan's books. His introductory book is called: SQL Server 2008 T-SQL Fundamentals. It's excellent.
Another great book is Joseph Sack's book: SQL SErver 2008 Transact-SQL Recipes.
It's...
"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 16, 2010 at 11:00 am
It's going to be hard to say what the issue is based on the information supplied. First, I'd look at the production wait states and queues. Figure out what is...
"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 16, 2010 at 8:50 am
Jeff Moden (8/16/2010)
"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 16, 2010 at 7:50 am
Dave Ballantyne (8/16/2010)
In todays there is a summary of one of my blog posts. It doesn't specify that it is a free web...
"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 16, 2010 at 7:49 am
Jeff Moden (8/16/2010)
"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 16, 2010 at 7:15 am
Not sure Jeff. Sent out a tweet to see if anyone knows who to contact for 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
August 16, 2010 at 7:08 am
GilaMonster (8/16/2010)
Jeff Moden (8/14/2010)
"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 16, 2010 at 6:14 am
Brandie Tarvin (8/12/2010)
"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 12, 2010 at 8:04 am
dennisv (8/12/2010)
I feel extra dumb now, but I did learn a lot here.
Thank you.
SELECT tblLocation.ID
FROM tblLocation
WHERE tblLocation.Route IS...
"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 12, 2010 at 4:10 am
Ray K (8/11/2010)
Grant Fritchey (8/11/2010)
How about Worcester?If you read German & English the correct pronunciation is, of course:
Vorchester
If you're from Massachusetts though, you'd say:
Woostah
Figure that one out.
So have you pahked...
"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 11, 2010 at 12:44 pm
How about Worcester?
If you read German & English the correct pronunciation is, of course:
Vorchester
If you're from Massachusetts though, you'd say:
Woostah
Figure that one 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
August 11, 2010 at 11:36 am
dennisv (8/11/2010)
Sorry, left over from speed trials.
I'd drop them then. They're going to hurt you, guaranteed.
I tried a TOP but it was a lot slower, but I did not...
"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 11, 2010 at 11:33 am
Have you looked at my response?
"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 11, 2010 at 10:52 am
I won't enter the debate about stored procedures or not.
You have some problems in your SQL code. First, why are you using DISTINCT for all the queries? This is...
"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 11, 2010 at 9:31 am
Viewing 15 posts - 14,476 through 14,490 (of 22,224 total)