Post reply

The Standard Edition Wish List

  • April 8, 2011 at 6:26 am

    #1309093

    Re your post, SQL dev licensing under MSDN has all of the features of enterprise. I run partitioning and testing on a pro workstation which I used to justify the upgrade to enterprise licensing by getting a 50* performance increase in one table.

    Worth checking the license agreements if QA is considered non-prod and can be done under MSDN licensing. I think MSDN is just restricted from productive use.

  • April 8, 2011 at 7:04 am

    #1309120

    Craig Farrell (4/8/2011)

    I'm with the others, partitioning. Primarily because I'd like to be able to test my partitions in dev/qa BEFORE it wanders up to production, and a lot of shops only splurge on the enterprise when it gets to prod.

    Craig, you should be able to use the developer edition on these servers. Just can't use it in production.

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • April 8, 2011 at 7:12 am

    #1309133

    I would really like to be able to use the OLEDB for DB2 driver on a Standard box.

  • April 8, 2011 at 7:27 am

    #1309153

    Data-driven Subscriptions for Reporting Services

  • April 8, 2011 at 7:35 am

    #1309161

    Would like to see compression in Standard edition.

  • April 8, 2011 at 8:27 am

    #1309207

    I would love to see "high performance" asynchronous Mirroring in Standard.

  • April 8, 2011 at 9:38 am

    #1309253

    online reindexing

  • April 8, 2011 at 9:43 am

    #1309260

    Fuzzy lookups in SSIS

  • April 8, 2011 at 10:52 am

    #1309301

    Besides what others have said I'd add database snap shots to the list.

    Someone mentioned compressed backups, this was added to standard edition for SQL Server 2008 R2. I was very happy about this one.

    ---------------------------------------------------------------------
    Use Full Links:
    KB Article from Microsoft on how to ask a question on a Forum

  • April 8, 2011 at 11:30 am

    #1309315

    PowerPivot

  • April 8, 2011 at 12:02 pm

    #1309333

    WayneS (4/8/2011)

    Craig Farrell (4/8/2011)

    I'm with the others, partitioning. Primarily because I'd like to be able to test my partitions in dev/qa BEFORE it wanders up to production, and a lot of shops only splurge on the enterprise when it gets to prod.

    Craig, you should be able to use the developer edition on these servers. Just can't use it in production.

    Yeah, I know, but most coding I do is on the shared dev/qa boxes which run standard, not my local sandbox.

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

  • April 11, 2011 at 8:04 am

    #1309833

    STD edition is used in many production evnvironment, SQL Audit would be most welcomed.

  • April 11, 2011 at 9:44 am

    #1309922

    CirquedeSQLeil (4/7/2011)

    Online reindex

    +Infinity

  • April 12, 2011 at 6:45 am

    #1310331

    I would like to see the Visual Studio Debugging add-in in the Standard Edition. I find it immensely helpful to be able to step through the stored procedure as well as the .net code.

  • April 12, 2011 at 12:14 pm

    #1310585

    Online reindex

Viewing 15 posts - 16 through 30 (of 32 total)

You must be logged in to reply to this topic. Login to reply