Meme Tuesday - Improvements to SQL Server
06 December 2011
|Why So Serious?
Yesterday’s funny post was about Meme Monday.
Today’s post is the sequel: Meme Tuesday. This is a more serious post.
Here’s a list of features and changes I wish Microsoft would make:
- Dynamic query re-optimization. If a query is doing badly, have the SQL engine detect that and re-optimized it on the fly for better performance.
- Give the MVPs even more influence over which SQL Server products are developed.
- Give DBAs the ability to create filegroups in tempdb, and assign different tempdb usages to each. I’d love to have user temp tables, sorts, hashes, RCSI data, and rollback data be separated, so I can tune them separately.
- Make Enterprise features available in Standard edition. Table compression and backup compression are at the top of my list.
- Object-level and index-level backups and restores. I would love to choose which of my nonclustered indexes to back up, because I don’t need most of them in emergencies.
- Let companies build their own PDW instances. Very few companies can afford the multi-million dollar price tag attached to a PDW appliance. They’ll usually pay somebody to change the code rather than
- Add built-in support for code libraries.
- Change your SQL Server 2012 licensing scheme to be roughly on par with the old prices. The current increase in prices is going to encourage adoption of NoSQL and open-source alternatives.