Viewing 15 posts - 2,386 through 2,400 (of 2,453 total)
In most organisations, MCDBA is unlikely to improve your salary or career path on its own. You need to show by your actions you are worth paying more.
In job hunting,...
May 13, 2004 at 4:12 am
Why are you not using NT only security. We do this on all our servers bar 1. The odd one is running some legacy web-based applications that require SQL authentication.
NT...
May 13, 2004 at 4:05 am
I completely agree with Brian.
There are a number of issues here...
1) Comparisom with other vendor's release stategy.
My main experience is with DB2. When IBM are near to making a new...
April 29, 2004 at 4:04 am
I would set the database offline. Even a single user connected would stop the DETACH working.
April 23, 2004 at 5:06 am
Use the same process as you would on a normal SQL Server database.
Connect to the MSDE instance in Enterprise Manager, right-click and select Properties, then set the required memory on...
April 23, 2004 at 4:57 am
The System Monitor disk counters can give misleading results with SQL Server.
SQL continually monitors how long it takes for a disk read request to complete. If I-O time is slow, SQL will...
April 21, 2004 at 8:25 am
There is very little on newsgroups or in Microsoft documentation about how W2000 or W2003 manages disk I-O. Certainly this is true when compared to mainframe z/OS, where ther are...
April 20, 2004 at 8:26 am
It is not possible to give generic advice about placing TempDB data and logs on the same controller. You will have to test this using your own hardware.
However, you can...
April 20, 2004 at 8:02 am
You should work with your SAN vendor in deciding which type of RAID to use. We are installing some HDS 9970v SANs, and have confidence in Hitachi's recommendation of formatting...
April 20, 2004 at 7:28 am
xp_Stopmail is fine to do on the command line, but beware of including it in an application.
One of our developers thought it would be 'safer' to wrap a xp_sendmail within...
April 14, 2004 at 6:32 am
You definitely need to troubleshoot MAPI problems by being logged on using the SQL Server service account. Anything else is normally a waste of time.
As to the question 'Why now?',...
April 14, 2004 at 3:48 am
The evaluation was done before I joined the organisation. We have done mini-evaluations since then, and confirmed that no other Windows-based replication tool offers superior facilities to D-T. Some match...
April 8, 2004 at 6:57 am
We are currently using Double-Take in production to replicate both databases and application files for Active/Passive failover. Our average latency between our current main and DR sites about 10 km...
April 8, 2004 at 4:55 am
As suggested, you can use TargetServersRole, but with modified permissions. This will allow users access to all jobs. If you give them the ability to add/change/delete jobs, this will apply...
April 7, 2004 at 2:58 am
If your database files took up 30GB of disk space when you made the backup, then you will need 30GB of spare disk space when you do the restore. This...
March 30, 2004 at 1:30 am
Viewing 15 posts - 2,386 through 2,400 (of 2,453 total)