Viewing 15 posts - 15,946 through 15,960 (of 22,226 total)
And I was actually questioned about why I would bother posting today's editorial[/url].
Why aren't you taking backups of 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
January 4, 2010 at 8:17 am
umailedit (1/4/2010)
Why should something as routine as backup not be done automatically by computers? Why depend on people to do the backup?
Speak of Murphy and he will appear. Right...
"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
January 4, 2010 at 8:16 am
If he runs scripts to create procedures like this:
CREATE PROCEDURE MyProc ...
instead of like this
CREATE PROCEDURE dbo.MyProc ...
--or
CREATE PROCEDURE myschema.MyProc ...
You'll see what's occurring. It will create 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
January 4, 2010 at 7:14 am
When this happens, you actually need a little bit of space to shrink the tempdb and you might not have it. One option would be to add another file 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
January 4, 2010 at 6:58 am
People have to set up the backup, monitor it and fix it when it goes wrong. The actual execution should be scheduled and automated, you're right. But far too many...
"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
January 4, 2010 at 3:46 am
Matt Miller (#4) (12/31/2009)
I'm not sure if this qualifies as heresy or not, or if it's "just plain wrong", but Darth had a close call the other day:
BWA-HA-HA-HA
That was good.
"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 31, 2009 at 8:59 am
To the Denizens of The Thread, posters & lurkers, may you all have a happy new year and many happy returns of the day.
And to the posters, with their urgent,...
"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 31, 2009 at 6:23 am
Shut down the server, muck with the file using an editor as Steve said, restart the server. Tada. Totally hosed database.
"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 8:42 am
Just adding a note to your original question and the excellent answer already provided.
Not only can you restore up the chain in terms of versions, but you can restore...
"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 7:25 am
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
Viewing 15 posts - 15,946 through 15,960 (of 22,226 total)