SQL Server News & Information tsql, performance tuning, industry trends, & bad jokes
tsql, performance tuning, industry trends, & bad jokes
This site is maintained by Jason Massie. He has 10 years experience as a DBA and has specialized in performance tuning for the last five. He was recognized by Microsoft as a SQL Server MVP. Jason has spoken at the Professional Association of SQL Server Conference, the North Texas SQL Server Users Group, SQL Connections and TechED. He has worked at Terremark (formerly Data Return) for nearly a decade.
You can contact him at jason@statisticsio.com or 469.569.5965
Abstracts addition Affinity Aggregation allocation Always Analysis Announced another API Appending article Authentication backup be Behavior between Bootstrapper Breaking Build Cache Caching Check checksums Codeplex collection Connecting contest Controller Creating CTEs CTP CUBE cursors Data Database DATALENGTH Debugging Design Diagnosing Diagnostic Differences Documentation DTS Emergency enhancement Entity ETW Exchange execution Express Extensions Fall February Filestream Filtered group GROUPING have Hosting Idle impact Improvement Increase Index Indexes Inserts Instances Interoperability Introduction IO large Late LOB local Localized Magazine Maintaining Maintenance Management maps March Microsoft minutes missing Mix Never November Offline OLE Online operations operators optimizations Optimized Overlapping Package Page Paging Panacea parallel part Partial Partition partitioned Partitioning PASS Performance PFS plan Plans Practices problem Problems Procedure Program programmatically Programming Protection Queries query read recent Recursive Related released Reports Restore return ROLLUP ROWCOUNT Runtime Security Select Sequence sequential Server Services set SETS Shooting shorts sizes Solutions Sortable SPARSE Spool SQL SQLIOSim SSIS Stalled Star Statement Statements stats Stored strategy Stuck Studio Submission Subreports Suggested Summarizing system Table Tables Tampa Task Than there through Timeouts Total Traces Transaction transfer Tricks Trouble TSQL turning understand Understanding undocumented Unique unused upgrade Upgrading Useful Value variables VDI Vista Will Windows Wireless
That is if you are on standard edition. I ran across the SQL Server 2008 SKU feature comparison PDF today. No big surprises. If it is a high availability or performance related feature, it is only going to be in enterprise only. Other new features in 2008 that are enterprise include transparent data encryption, resource governor(although "Predictable query performance" is listed as standard), SQL audit and any kind of compression. So what does that leave new in SQL Server 2008 Standard Edition? Policy based management, data collections, intellisense, the new tsql and the new datatypes?
If I put myself in my VP's shoes, it would be hard for a DBA to convince me that this upgrade was really necessary if we are already on SQL Server 2005 Standard Edition. Am I missing something? Here is the new feature matrix.
I am all about MSFT making money. I am long. However, we need a reason to give more money particularly if we are already on SQL 2005. If people are still on SQL 2000 in Q4+, upgrading to SQL 2008 should be a no brainer providing it is stable.
I understand that Microsoft does not expect people to upgrade every release with the 2-3 year release cycle. Missing from the PDF details on workgroup, express and web edition. Also this disclaimer is in the PDF:
"
This document was developed prior to the product’s release to manufacturing, and as such, we cannot guarantee that all details included herein will be exactly as what is found in the shipping product. The information contained in this document represents the current view of Microsoft Corporation on the issues discussed as of the date of publication. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information presented after the date of publication. The information represents the product at the time this document was printed and should be used for planning purposes only. Information subject to change at any time without prior notice.
posted @ Monday, April 21, 2008 12:55 PM by Technical Thoughts of Jorriss
Name (required)
Email (required)
Website
Notify me of followup comments via e-mail