April 7, 2011 at 9:15 pm
Comments posted to this topic are about the item The Standard Edition Wish List
April 7, 2011 at 10:19 pm
Online reindex
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 7, 2011 at 11:15 pm
Data-driven Subscriptions for Reporting Services.
April 8, 2011 at 12:17 am
Partitioning
April 8, 2011 at 12:21 am
Online index rebuild
April 8, 2011 at 1:06 am
Hi,
I am very happy to see that this is not only my issue and there are a lot of peoples that are stuck like me with Standard edition because tight budgets, i really wish to have only two things and i'll be pleased to have limitations and i'll find solutions some how, i am talking about partition table and it's ok to have a limit of 1000 partitions, also compress backups to eliminate 3rd party product that we are using only because of the compress backups option, my native (...one set) of backup file is almost 300 GB and we have a 'write' pace to the database something near 95%, we are a financial /brokers company, i am doing backup to transaction logs on each 10 minutes and the files are sized between 500 MB & 2 GB of database changes, that's why i want this backup to be compressed also in the standard edition.
I can ask/wish also for the online rebuild index but i know that this will not be inside, even what i wrote about the partition tables and compressed backups, thanks to let us say something even that none of this will be added, i am a DBA for almost 16 years in SQL Server and i didn't saw any 'miracles' or 'wish lists' happens for real, thanks anyway.
Best regards,
Victor S.
April 8, 2011 at 1:28 am
Snapshots. I would be even very happy with only 1 snapshot per instance.
April 8, 2011 at 1:46 am
I would like if Microsoft added for Analysis Services Semi-additive measures and Perspectives to the Standard Edition.
Kind regards,
Peter den Herder
April 8, 2011 at 1:59 am
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.
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 8, 2011 at 2:16 am
Transparent Data Encryption (TDE)
April 8, 2011 at 3:26 am
Partitioning is the main feature followed by online index work. I'd happily pay for Standard Edition and then an extra fee to plug in the features I wanted if needs be. Justifying the cost of Enterprise is too hard to do at the moment although there is obvious benefit if I had it. Effectively the money goes elsewhere (such as hardware) in order to work around this.
April 8, 2011 at 4:45 am
Data Driven Subscriptions in SSRS and Fuzzy Grouping in SSIS.
We've got less than 40gb of data in SQL (80% of that is a document imaging system and SharePoint). We can't justify Enterprise - but I've invested lots of soft cost (my time) in these two.
Mitch
April 8, 2011 at 5:55 am
Data Driven Subscriptions in SSRS.
April 8, 2011 at 5:58 am
I would like to see online index rebuilds as part of the standard edition. Also i would like to see the code based changed so you do not have to use the NOEXPAND hint when calling indexed views. Both of these are native to Enterprise. Why? The only reason i come up with is so you have to pay more!
Jimmy
"I'm still learning the things i thought i knew!"April 8, 2011 at 6:15 am
Chalk up one more vote for online index rebuilds.
Viewing 15 posts - 1 through 15 (of 32 total)
You must be logged in to reply to this topic. Login to reply