Viewing 15 posts - 1,411 through 1,425 (of 2,496 total)
If you have done an in-place upgrade it would be wise to do all of the OP statements. If you have done a new install then the DBCC CHECKDB(db_name)...
March 23, 2009 at 4:49 am
For a new installation, the best option is to use SQL Server 2008 64-bit on Windows 2008 64-bit (Or Windows 2003 64-bit if desperate). This will give you...
March 23, 2009 at 3:51 am
I agree. Backup and restore is simple, reliable, and effective.
If you want to automate things you have to write your own script, but this is not a...
March 20, 2009 at 4:25 am
Look at Remote Distributor in BOL. We are implementing this technique to reduce bandwidth usage.
Currently we have a number of SQL boxes at a remote site that...
March 20, 2009 at 4:18 am
The space used stats can be stale. This is particularly true in SQL Server 2000, and still apllies to a lesser extent to SQL 2005.
It is worth running DBCC...
March 20, 2009 at 4:04 am
Does it matter what language SQL Server or anything else is written in?
The important question is 'Does it meet its objectives?'. IMHO the answer with SQL Server...
March 19, 2009 at 3:53 am
Please talk to your Windows support people before changing the Windows page file size. If you move away from your site standards you will not get any thanks.
Many people...
March 19, 2009 at 3:41 am
You can get all the users you want to hide databases from into a Windows group.
You then grant SQL logon to the group, then issue a 'DENY VIEW ALL DATABASES...
March 19, 2009 at 3:34 am
Be aware that an in-place upgrade to SQL Server 2005 can fail leaving SQL totally unusable. You need to include this scenario in your planning.
If this happens, your options...
March 19, 2009 at 3:31 am
Google can find you instructions for upgrading from SQL 6.5 to SQL 7, which was a major change in file format. I would be surprised if anything above SQL...
March 18, 2009 at 7:17 am
This is easy. You need to remove the 'BUILTIN/Administrators' account from SQL Server.
Before you do this, you need to add an account the DBAs can use to manage SQL...
March 18, 2009 at 4:25 am
The syntax you are using looks like SQL Server 7 or above. Different syntax was used in older versions, but I do not know the details. Hopefully someone...
March 18, 2009 at 4:15 am
Don't forget that SQL Server 2005 is 4 years old so I hope you are comparing to a 4-year old version of Oracle.
The answers are:
1) Yes. This is...
March 18, 2009 at 4:00 am
You can run the SC command from vbscript to do this work. Remember to add the new account to the relevant local group in order to pick up the...
March 18, 2009 at 3:38 am
Yes, you can have 1 instance with AWE and 1 without. You should try various combinations to see what works best for you.
March 17, 2009 at 9:10 am
Viewing 15 posts - 1,411 through 1,425 (of 2,496 total)