Viewing 15 posts - 16,006 through 16,020 (of 22,232 total)
I'll be working both weeks. As a matter of fact, our job in these two weeks is to discourage development teams from "deploying before the end of the year" in...
"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 21, 2009 at 6:39 am
mike_walsh (12/20/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
December 21, 2009 at 6:28 am
Hey Jeff,
Thanks for the great review and the kind words. "I'm not worthy" doesn't begin to cover it, but thanks for the sentiments.
"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 20, 2009 at 4:45 am
I'm glad it worked. Thanks for the praise on the books. I'd follow Gail's suggestions if I were you.
See you at the next Data Camp on January 30th?
"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 20, 2009 at 4:43 am
Alvin Ramard (12/18/2009)
I don't know if I like this idea. There's already too many places for people to go ask questions.
Yes & no. How many SQL...
"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 18, 2009 at 1:30 pm
I figured he had it all running on FoxPro. Was I wrong.
Oh, and 7000 posts. Yahoo.
"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 18, 2009 at 11:01 am
CirquedeSQLeil (12/18/2009)
Can you help me 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 18, 2009 at 10:59 am
I've been running SQL Server with Word open while I worked on a document and used Snagit to do screen captures at the same time. No issues yet. I'm going...
"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 18, 2009 at 10:21 am
This won't completely answer your question either, but it'll provide quite a bit of information for you.
Use the the dynamic management views for indexes. I'd suggest starting with sys.dm_db_index_usage_stats. 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
December 18, 2009 at 9:10 am
Steve Jones - Editor (12/18/2009)
Grant Fritchey (12/18/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
December 18, 2009 at 8:56 am
GabyYYZ (12/18/2009)
Grant Fritchey (12/18/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
December 18, 2009 at 8:51 am
Gail already told you how to see what's taking the longest.
Identifying which stats are useless is difficult. You'll have to monitor the servers for a long period of time and...
"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 18, 2009 at 8:46 am
The statistics on the Voucher table look like they might be out of date. Estimated row count = 149 and actual = 4850298. Same thing with the loop join. 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
December 18, 2009 at 8:36 am
The order in which you place these things and whether or not you place the criteria in the ON or WHERE cluase (at least for INNER JOINS) does not matter....
"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 18, 2009 at 8:16 am
I'm not sure if it's a skill, although it must partly be.
One old story. I wrote an app for managing user access to a database and turned it over 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
December 18, 2009 at 8:11 am
Viewing 15 posts - 16,006 through 16,020 (of 22,232 total)