Home Forums SQL Server 2008 SQL Server Newbies SQL 2008 R2 Standard vs Enterprise on Parallelism RE: SQL 2008 R2 Standard vs Enterprise on Parallelism

  • June 11, 2014 at 3:08 pm

    #1720907

    ...what's missing from Standard SQL edition where parallelism is concerned. I thought it was only for special index operations... are we talking about two different things?

    I just wanted to add that I think you are talking about two different things... If you look at Features Supported by the Editions of SQL Server 2008 R2 under Scalability and Performance you will notice that Parallel index operations are only supported by Datacenter and Enterprise Editions. Perhaps that is what your analyst was talking about.

    Parallel Query Processing, on the other hand, is supported by all versions of SQL Server 2008 (and earlier but I don't know the details of hand) provided that you have 2 or more CPUs.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001