All Products

Browse Categories

logo

|Promotions||

Lenovo 01DC307, Microsoft SQL Server 2017 - License - 5 user CALs - ROK - Linux, Win - EMEA

01DC307

In Stock
$16,610.00
Quantity
In Stock

Freight Calculator

  • Brand: Lenovo
  • Model: 99X364538
The Lenovo MS-SQL-2017 software is designed for efficient data management, offering amazing compression in data size and operator pushdown capabilities. Ideal for IT professionals and businesses looking to streamline their data operations.

Need Help or Found it Cheaper?

Chat with our experts for product advice or price matching on genuine written quotes.

 

Highlights

  • Amazing compression in data size
  • Operator pushdown
  • Batch mode processing

Marketing description

Microsoft SQL Server 2017 has made significant improvements in data warehousing technologies and performance, including column-store features as well as many other improvements. Column-store indices offer great advantages over traditional row stores for analytics and data warehousing queries. They are ideally suited for the star schemas, and tables with billions of rows which are commonly seen.

Product Features

 

  • Amazing compression in data size
    Data warehouses are very large by nature, and the compression offered by column store index technologies offers both space and cost savings, but also significantly increased performance, due to the dramatically reduced IO requirements given by the compression, coupled by the ability to only scan the specific columns required by each query. Compression also reduces the amount of memory required to hold a given number of rows from the source data warehouse.
  • Operator pushdown
    Pushdown refers to moving both filter and aggregation query operations closer to the data, so that many of the filters and calculations can be done in the scan operators, dramatically reducing the volume of data which needs to be handled further on in query processing.
  • Batch mode processing
    Microsoft SQL Server 2017 offers enhancements in batch mode processing which processes many rows at a time rather than serially doing calculations on each individual row. These batch operations are further optimized by leveraging Single Instruction Multiple Data (SIMD) vector processing CPU instructions in the Intel architectures.
  •  
Zotim is a trading name of Zcompute Pty Ltd (ABN 94 613 746 535) — © 2026 Zcompute Pty Ltd. All rights reserved.