Viewing 15 posts - 376 through 390 (of 1,536 total)
EXEC sp_configure 'show advanced option', '1';
RECONFIGURE;
EXEC sp_configure 'Database Mail XPs',1
reconfigure
EXEC sp_configure 'show advanced option', '0';
RECONFIGURE;
February 9, 2009 at 7:20 am
It very much depends on how your data grows. It could be anywhere from 10MB to 1GB. First thing you should do is proactively manage your file growth. Look for...
February 9, 2009 at 5:36 am
What's the table schema? What's queries are you trying to run? What are the indexes like? What level of fragmentation do you have? What do perfmons on the server look...
February 6, 2009 at 5:10 am
Define "degrade"
What is the issue and in what capacity are you receiving a problem?
February 5, 2009 at 12:18 pm
Don't shrink the log file is my first recommendation, if it's going to grow again it really doesn't make much sense.
Backup the log a couple of times a day,...
February 5, 2009 at 7:13 am
Your best bet would be to move them to another database that you have a full recovery model on.
To help with preventing code changes you could actually use a synonym...
February 5, 2009 at 6:59 am
2009-02-05 02:18:26.94 spid55 Autogrow of file 'stdfqads_Log' in database 'stdfqads' took 66500 milliseconds. Consider using ALTER DATABASE to set a smaller FILEGROWTH for this file.
This indicates...
February 5, 2009 at 6:11 am
I would start by checking your disk queue lengths within perfmon, if the values are large then ascertain the current i/o throughput on those disks.
Identify all processes that may be...
February 4, 2009 at 5:31 am
Certainly works pushing data to Oracle (haven't tried it the other way).
Just make sure that you have the Oracle client software installed and the TNSNAMES/SQLCLIENT files correctly configured prior to...
February 4, 2009 at 5:25 am
That's one for people smarter than me to answer (:
February 3, 2009 at 7:25 am
You could run a query to check which values don't match. Only those need updating. Unless every single vendor makes a change the impact should be pretty small.
February 2, 2009 at 2:01 pm
Bear in mind you only have to change a row if the value has been updated and you need to use a different code.
Anything not changed will not have to...
February 2, 2009 at 1:54 pm
I've yet to see a solution that will back up a database in anything other than dumping to a phyical backup file outside of some SNAP utility on a SAN.
February 2, 2009 at 1:19 pm
I'd never use Arcserve to backup anything other than the dumped SQL backups which you mentioned you were doing.
Certainly NEVER use the SQL agents to backup your databases. In 3...
February 2, 2009 at 12:51 pm
Viewing 15 posts - 376 through 390 (of 1,536 total)