One of the aspects of MAXDOP that is missed by many people is that MAXDOP applies to each portion of the plan, not to the overall statement.

For example, look at...

Even if you are using Enterprise Edition for development purposes only, you need a vaild license.

If you have a TechNet license, or the appropriate level of MSDN license, then you...

There are some things to consider..

1) Task Manager on a 32-bit server cannot show memory use above the 4GB line. Even if your SQL instance has 20GB AWE memory...

You can play with the installation rules and get Enterprise Edition installed on XP. Personally I cannot see any point in doing this apart from showing that it can...

In the UK there are many small loyalty schemes, and 2 big ones - Nectar and Tesco. Both of these span multiple companies that have no common ownership. ...

When you enable Service Broker you are enabling it for User processes. The End Points you set up are User end points. It is always enabled for System...

Using SAN snapshotting may be your best way, but there is another approach that would work.

You could keep your reporting server reasonably up to date by shipping database backups. ...

I agree with Lowell and RBerryYoung.

What you want to do is like asking for a single paragraph to be written in English and German that means exactly the...

Get expert help. 40TB is a leading edge system and very few people will have the experience to give you useful advice. You will find problems at the...

I have experience of a similar situation but using HDS kit.

It can work very well providing the data and log volumes are in the same synchronisation set. In HDS...

There are no additional security concerns about putting Developer Edition on to a Workstation compared to having SQL Express or SQL Embedded Edition on the Workstation, and these latter two...

Youi may find SQL FineBuild helpful. You can gt this either by following the link below or direct from CodePlex.

SSAS in 32-bit mode looks at the physical memory available on the box as reported by Windows, and limits its use within that. Therefore it will give you an...

There are 32-bit and 64-bit version of all of SQL Server 2000, 2005 and 2008.

The 64-bit version of SQL Server 2000 is for database services only, most other components run...

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...