Viewing 15 posts - 1,456 through 1,470 (of 2,496 total)
One potential issue with DNS aliases is getting them changed. At my old place we had servers in GB and US (with no clustering), and wanted the applications to...
February 25, 2009 at 5:34 am
In your situation you will not get any extra benefits from applying Lock pages in memory.
February 25, 2009 at 5:20 am
The counters show that you are successfully using AWE. What problem do you think you have?
February 24, 2009 at 8:19 am
Each lock uses exactly the same amount of memory. I think Books Online has the details of how big this is.
If you have 20 rows in a table locked,...
February 24, 2009 at 5:56 am
Steve is right. The sa account can have any password without impaqcting on how SQL Server operates.
Anyone who has sysadmin authority can change the password of the...
February 24, 2009 at 5:48 am
If you Google Surrogate Key you will find lots of opinions, often in opposition to other opinions and sometimes (excessively) strongly held. The main viewpoints are 'Never', 'It depends',...
February 24, 2009 at 5:44 am
The suggestion about using your firewall or network switch configuration is the best way to achieve this.
One way to think of the TCP address and port numbers is to think...
February 24, 2009 at 5:32 am
Persnally, I think having a level of indirection between your applications and the hardware is a good thing. All SQL Server machines should be given a DNS alias, and...
February 24, 2009 at 5:19 am
If you download SQL Server FineBuild from Codeplex, you will find the spSetDBMaintenance stored procedure creates database backup jobs for all databases that do not already have a backup.
The jobs...
February 24, 2009 at 5:12 am
PAE is automatically enabled only if the server is
using hot-add memory devices
This does not prevent you from adding /PAE to BOOT.ini even if you have hot-swap memory. All...
February 24, 2009 at 5:07 am
Google tells me that it is free with Sysinternals tools.
It runs a NTFS defrag on named files only.
February 23, 2009 at 6:58 am
What TCP port have you specified for these instances. If you are trying to use the same port for both instances, you can conect only to the first instance...
February 23, 2009 at 2:55 am
Lots of good advice has already been given, but here is my bit...
Try Google to find if there is a SQL Server user group near you. They often have sessions...
February 20, 2009 at 9:00 am
Are you trying to copy DTS packages or copy data?
If you are copying DTS packages, IMHO the best option is to export and import using DTSBACKUP2000. This will keep...
February 20, 2009 at 8:46 am
If you have a document showing what options were used in the original install, or scripts that did the install, that is the best choice.
If you have to start from...
February 20, 2009 at 8:41 am
Viewing 15 posts - 1,456 through 1,470 (of 2,496 total)