At its PASS conference , Microsoft has for the first time about the future version of SQL Server spoken of his. The product, code-named "Denali" is column-oriented indices and other storage methods in its OLAP engine to provide. It should result in data warehouse queries and aggregations can run much faster. A White Paper (PDF) According to this technique are columns in a number of disk blocks, as would otherwise normally lines.

Thus, the server only the query needed to columns of the plate to get by because of the redundancy within a column the data is often more compressible, and intermediate buffer can be better exploited, as the compressed and frequently used parts of the columns in the memory are already available. As a further innovation, the company announced a joint development environment for database, reporting, and Web software under the umbrella of Visual Studio. It will include a unified environment for working with databases, the round-trip refactoring and start of databases contain and cover so that their entire life cycle.

With the availability of Microsoft wants to catch up to the competition. Asked that the administration of HA systems with a uniform surface possible, which is both local and Subnets cluster, synchronous and asynchronous mirroring, and for shared responsibility and non-shared storage. Data stored in the fallback node data is the first time for read access available, and it can be defined several of them per master. Oracle inspired appeared that the new file tables to be: This allows database tables such as file systems to use. Minor changes in the functions of the spatial data should give it more speed in full-text search. For future reports is a web interface, the Silverlight support their creation and editing allowed.