• All of the differences between Standard Edition and Enterprise Edition are not published. Those that are published is too long of a list to try to write out from memory.

    First thing though is that parallelism is in ALL editions of SQL Server. Even the current versions of SQL Express. Parallelism is absolutely available in Standard Edition. The Analyst should go back to analyzing and leave the DBA duties alone.


    My blog: SQL Soldier[/url]
    SQL Server Best Practices:
    SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]