Hero image 0 of Microsoft SQL Server 2017 1 User, 0 of 1

Microsoft SQL Server 2017 1 User

(No ratings yet)

Key item 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.
Product Type: License
Category: Business applications - databases / database tools
License Qty: 1 user CAL
Licensing Program: Reseller Option Kit (ROK)
Platform: Linux, Windows
Localization: EMEA

Specs

Operating System
Linux; Windows
Brand
Lenovo
Number of Users
1
Physical Media Format
Digital Download
Version
2017
Model
01DC305

Current price is $344.16

Price when purchased online

Out of stock

How do you want your item?

Out of stock

About this item

Product details

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.

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.
Product Type: License
Category: Business applications - databases / database tools
License Qty: 1 user CAL
Licensing Program: Reseller Option Kit (ROK)
Platform: Linux, Windows
Localization: EMEA

info:

We aim to show you accurate product information. Manufacturers, suppliers and others provide what you see here, and we have not verified it.

Specifications

Computer Software Type

Servers, Development & DBMS Software

Operating System

Linux; Windows

Brand

Lenovo

Number of Users

Warranty

Warranty information

NONE

Please be aware that the warranty terms on items offered for sale by third party Marketplace sellers may differ from those displayed in this section (if any). To confirm warranty terms on an item offered for sale by a third party Marketplace seller, please use the 'Contact seller' feature on the third party Marketplace seller's information page and request the item's warranty terms prior to purchase.