Viewing 15 posts - 1,261 through 1,275 (of 1,319 total)
Well your "sanity-check" appears right on for you business needs. If your small and can do the maintenance jobs daily, cool. I personally think daily rebuilds are overkill in a...
-- You can't be late until you show up.
March 18, 2008 at 7:05 am
Differentials are not an option in the maintenance plan but you can script it into a job. Daily index rebuilds - is that really necessary for your environment? Backups to...
-- You can't be late until you show up.
March 17, 2008 at 7:40 am
You can use DBCC INDEXDEFRAG. I'm sure there will be some type of performance hit but you can run this while the application is in use.
-- You can't be late until you show up.
March 17, 2008 at 7:28 am
Jeff, Checked out your article and besides complimenting you on it, I have a question..how did you get this article into the future? Is that another of your many skills?...
-- You can't be late until you show up.
March 14, 2008 at 1:18 pm
Can you post the SQL statement that is failing?
-- You can't be late until you show up.
March 14, 2008 at 1:02 pm
I'm not firewalled from the site but cannot get in. They appear to be having issues or have shutdown. I cannot find any copies, yet. I will re-post if I...
-- You can't be late until you show up.
March 14, 2008 at 12:38 pm
Amazing how many times I've seen a similar post over the past couple of weeks! One of the first tasks a DBA must do when getting the job is to...
-- You can't be late until you show up.
March 13, 2008 at 8:40 am
I agree with maintenance plans. All system databases weekly, all user databases, minimum, nightly (that's OUR strategy and may not fit your needs). With All user databases checked, if someone...
-- You can't be late until you show up.
March 13, 2008 at 7:21 am
Please provide detail. What are you attempting to do? What tool(s) are you using? Provide the scripts if possible. Not really sure what you're asking other than "Backup Failes". Not...
-- You can't be late until you show up.
March 7, 2008 at 1:11 pm
I was getting a SQLHandShake failure from time to time on some backup jobs going to a remote server. Added the entry to the HOSTS file and haven't seen the...
-- You can't be late until you show up.
March 7, 2008 at 12:48 pm
With just a little extra effort, it's amazing what you can do! Boo to the naysayers!
-- You can't be late until you show up.
March 7, 2008 at 6:58 am
Or better yet, avoid using reserved words as a column or table name! You'll also need [ ] around any names that contain spaces, i.e. [Data Base], when referencing them...
-- You can't be late until you show up.
March 6, 2008 at 12:57 pm
I'd use Profiler. You can trap all kinds of info. Be aware of potential performance degradation if you're running it on a lot of events for an extended period of...
-- You can't be late until you show up.
March 6, 2008 at 12:48 pm
I have to agree with Philip about the disk subsystem. Are any errors being raised? Can you backup a smaller database using Redgate? I don't believe it's the backup software....
-- You can't be late until you show up.
March 6, 2008 at 10:18 am
As has been stated, you've added the network component into the mix. Backing up to a SAN is going to be slower than a local backup. Did you look at...
-- You can't be late until you show up.
March 6, 2008 at 9:55 am
Viewing 15 posts - 1,261 through 1,275 (of 1,319 total)