Viewing 15 posts - 15,991 through 16,005 (of 22,221 total)
Just to follow on to what Gail said, and hopefully reinforce it, index hints, any query hint, should be avoided. More often than not, fixing either the query or the...
"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 7:04 am
When you say backup, do you mean that you have a script that looks similar to this:
BACKUP DATABASE mydatabasename TO DISK = '\\someserver\someshare\mydatbasename.bak'
Or are you doing something else entirely?
"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:59 am
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
Viewing 15 posts - 15,991 through 16,005 (of 22,221 total)