Viewing 15 posts - 1,246 through 1,260 (of 2,497 total)
Windows 32 bit can directly address 4GB RAM.
First, lets look at the situation ignoring Windows /PAE switch and SQL AWE memory...
Everything that uses memory must fit into the...
July 20, 2009 at 2:57 am
Is 'Show Advanced/All Properties' checked? You do not see the option you need unless advanced properties aer shown.
July 17, 2009 at 8:19 am
Sorry, I am out of ideas.
July 17, 2009 at 8:17 am
Registry access is often the problem, but ther can be other blocks to getting this working...
It is worth trying to control the services using a different tool as part of...
July 17, 2009 at 6:25 am
The default security model in Analysis Services is that the local Administrators group has ServerAdmin access and nobody else has.
A system administrator can grant ServerAdmin access to the DBA group,...
July 17, 2009 at 5:37 am
You need remote access to the target machine registry. Some sites lock this down, so you may need to talk to your Windows people to see what has been...
July 17, 2009 at 5:31 am
Lots of good advice in this thread!
Another way that anything relying on a MAC address can produce duplicate results is that you are relying on all MAC addresses being globally...
July 16, 2009 at 5:24 am
You will need to take disk images of all drives that contain program files that will be involved in the upgrade.
Some of the problems you encounter may leave you with...
July 16, 2009 at 5:09 am
I have some involvement in redundancy councelling, and would add some other points...
Do not be surprised if you feel low or depressed. Most people find the disruption to their...
July 16, 2009 at 5:02 am
There is a choice:
1) You can be lazy and put the SQL service account in the local Administrators group. In this situation you give SQL Server more rights than...
July 15, 2009 at 5:44 am
I agree with Rudy.
If you want to look at building your own conversion routine then look for 'Packed Decimal' or 'comp-3' in Google.
It will be quicker and easier...
July 13, 2009 at 10:00 am
On a 32-bit server the Perfmon TargetServerMemory results and Task Manager will never report more than 4GB memory in use.
In order to see if you are using more than 4GB...
July 10, 2009 at 6:01 am
In order to set up a custom role in msdb that inherits the capabilities of SQLAgentOperatorRole (or any other role) you need to do the following...
1) Create your role
2) Add...
July 9, 2009 at 3:53 am
In SQL Server 2005 and above, all tables have the capability of supporting multiple partitions. By default all data is kept in a single partition.
If you want to use...
July 8, 2009 at 5:41 am
Viewing 15 posts - 1,246 through 1,260 (of 2,497 total)