Viewing 15 posts - 14,491 through 14,505 (of 22,232 total)
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
there's not really a good way and, frankly, you shouldn't. TSQL is a great language for querying databases and manipulating data. It's quite horrible at all other tasks. I'd suggest...
"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:14 am
GilaMonster (8/11/2010)
2008 feature, along with the two options (access check cache bucket count, access check cache quota) that control the token store.
Nuts. Thanks. I wasn't sure when it was introduced.
It...
"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 6:08 am
Nope. There is no way to control the cache in that manner. The one thing you can do, and I think this is available in 2005, is set the system...
"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 5:39 am
And for a slightly different view of the same material:
http://scarydba.wordpress.com/2010/07/23/sql-university-introduction-to-indexes-part-the-third/%5B/url%5D
"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 5:37 am
No, I don't recognize that wait state. Sorry.
Have you run this DMV, sys.dm_os_wait_stats, and collected stats from it? Before, during & after your peak times will tell you quite 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 10, 2010 at 1:28 pm
GilaMonster (8/10/2010)
Agreed, but since the rebuild recreates the entire index regardless of what state it's in, it shouldn't be affected by how fragmented the index is, whereas the reorganise likely...
"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 10, 2010 at 1:16 pm
Red Gate SQL Compare Pro comes with a command line utility. It can be completely automated.
"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 10, 2010 at 12:38 pm
Viewing 15 posts - 14,491 through 14,505 (of 22,232 total)