Viewing 15 posts - 15,991 through 16,005 (of 22,219 total)
Are you learning for yourself or for your business? If your business, learn what they're using. For yourself, go to 2008. Anything you learn there is not wasted, it transfers...
"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:45 am
You need to provide a little more information for what you're looking for. Monitoring what? There are lots of things you could monitor on the server, performance, access, data, 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 21, 2009 at 6:43 am
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
Viewing 15 posts - 15,991 through 16,005 (of 22,219 total)