Viewing 15 posts - 15,961 through 15,975 (of 22,232 total)
Excellent, excellent, excellent post. Nothing is more important than verifying backups, except, verifying that you know how to run a restore. You're absolutely right when you say that backups are...
"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 30, 2009 at 5:28 am
Lynn Pettis (12/29/2009)
Kassondra was in a car accident Sunday...
"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 29, 2009 at 1:17 pm
GSquared (12/29/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 29, 2009 at 11:00 am
I agree, I'd start with Maintenance plans since you're just starting out.
The mechanism for scheduling operations within SQL Server is a service called SQL Server Agent. By default it's installed...
"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 29, 2009 at 6:42 am
You don't mean sp_configure do you? All the SQL Server settings, memory allocation, all that stuff? Or are you really looking even lower level at the server instance itself? If...
"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 29, 2009 at 6:11 am
klnsuddu (12/28/2009)
If the Index rebuild maintenance plan run on weekly basis, then NO need to run Update statistics maintenance job?thanks
You will still need to update statistics. I'm pretty sure 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 29, 2009 at 5:19 am
jcrawf02 (12/28/2009)
Grant Fritchey (12/28/2009)
I've also been playing a lot of Call of Duty Modern Warfare 2.
I've been instructed that we will have a Christmas: Take 2 for New Years, 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 28, 2009 at 11:47 am
Steve Jones - Editor (12/28/2009)
you're welcome to come out here. We have land, Scouts, and snow 🙂
Keep the snow. The rest sounds great. Now, are there jobs?
"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 28, 2009 at 11:46 am
river1 (12/28/2009)
But , with this apps can people be notified by this two ways? e-mail and mobile phone message?
Both of the ones I mentioned work with either. After all, 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 28, 2009 at 11:45 am
Steve Jones - Editor (12/28/2009)
Grant Fritchey (12/28/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 28, 2009 at 9:18 am
GilaMonster (12/28/2009)
Grant Fritchey (12/28/2009)
I'm not even remotely a Star Wars fanboyAaahhh... Heresy!
😀
Yep, speak it fluently.
"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 28, 2009 at 9:16 am
GilaMonster (12/28/2009)
Am currently...
"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 28, 2009 at 8:54 am
Yep, no need for a dba.
Need fewer developers too since you can use objects already developed in the cloud.
It's the end of 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
December 28, 2009 at 8:47 am
There is a mechanism, and after you look it up as Jeff is prompting, you need to know that it's not 100% accurate all the time.
"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 28, 2009 at 8:44 am
Not enough information to help you unfortunately.
To get a complete answer, please post the execution plan, some sample data and the structures involved. To get a partial answer, at least...
"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 28, 2009 at 8:39 am
Viewing 15 posts - 15,961 through 15,975 (of 22,232 total)