Viewing 15 posts - 436 through 450 (of 2,496 total)
A lot of space in the MDW can be taken for system objects. I suggest you look at http://support.microsoft.com/kb/2793580 to see how to exclude system objects.
June 2, 2014 at 4:07 am
Another way to limit CPUs is to use the Windows NUMPROC boot-time option. This limits the number of processor cores presented within Windows. If you use NUMPROC 20...
May 22, 2014 at 10:01 am
You could look at SQL Server Compact Edition. This can be installed either by running a .msi file or by copying the .dll files to the right location.
Some more...
May 22, 2014 at 9:55 am
we have to match all data together across 3 fact tables and 30 dimensions for reporting
I feel your pain. It is because we have similar problems that we are...
May 21, 2014 at 2:56 am
If using an AD account it needs to be in the LocalAdministrators group
This is wrong. There is no need for any SQL Server service account to be given windows...
May 21, 2014 at 2:47 am
See http://sqlserverfinebuild.codeplex.com/wikipage?title=Change%20Proxy%20Account%20password.
Also see http://sqlserverfinebuild.codeplex.com/wikipage?title=SQL%20Server%20Proxy%20Accounts for some general advice about proxy accounts.
May 20, 2014 at 6:47 am
When you changed the passwords in Windows, did you refresh the passwords held within SQL Server? If not then SQL Server will still try to log on to the...
May 20, 2014 at 2:40 am
What version and edition of SQL Server are you using? SQL Agent is not available for SQL Express Edition.
If the service account for SQL Agent set up as a...
May 20, 2014 at 2:38 am
As a general rule, including an OR in the WHRE clause will prevent the optimiser from using an index. This can be confirmed in your situation by looking at...
May 19, 2014 at 5:11 am
I think you need to define more about what type of analytics you want to do, and the product set you currently use to do it. There are many...
May 19, 2014 at 4:08 am
You need to talk to your MS license reseller to get a definitive answer on this. If your reseller makes a mistake they are contractually obliged to stand by...
May 16, 2014 at 3:34 am
I'll be there on Saturday
May 16, 2014 at 3:02 am
There is no supported method to downgrade from Enterprise to any lower edition (BI, Standard or whatever).
In theory you can uninstall SQL Enterprise and install SQL Standard. For a...
May 16, 2014 at 2:56 am
If you are using Standard Edition there is not much to tempt you.
The Buffer Pool Extension feature will help performance if you have SSD storage and are memory-constrained,...
May 12, 2014 at 9:57 am
My main objective would be to reduce risk, so I would aim to build a new cluster. You are using SQL2012 so you can use an AG to get...
May 12, 2014 at 3:42 am
Viewing 15 posts - 436 through 450 (of 2,496 total)