Select Page
hidden-column

Clustered Columnstore Index: Massively Parallel Trickle Insert

A traditional scenario of loading data into CCI is a nightly load from one or more data files containing millions of rows. Recommended technique is to load the data with batchsize >= 102400 as explained https://blogs.msdn.microsoft.com/sqlserverstorageengine/2014/07/27/clustered-column-store-index-bulk-loading-the-data/. However, we are seeing ... continue reading
azure iot pipeline with sql

Working with Azure IoT data in Azure SQL Database

IoT use cases commonly share some patterns in how they ingest, process, and store data. First, these systems need to ingest bursts of data from device sensors of various locales. Next, these systems process and analyze streaming data to derive ... continue reading
In-Memory OLTP Indexes – Part 1: Recommendations.

In-Memory OLTP Indexes – Part 1: Recommendations.

In-Memory OLTP Indexes In-Memory OLTP technology, available in Azure SQL Database and SQL Server, can significantly help you in improving the performance of applications that require high throughput and low latency online transaction processing, high volume concurrent data ingestion (Internet ... continue reading

Import and analyze IIS Log files using SQL Server

IIS generates logs where are recorded many information about HTTP requests such as what Url was called, when the request happened, what is the origin, etc. If you want to analyze information from log files you can use use text ... continue reading
contosodwsales

Extreme 25x compression of JSON data using CLUSTERED COLUMNSTORE INDEXES

CLUSTERED COLUMNSTORE INDEXES (CCI) provide extreme data compression. In Azure SQL Database and SQL Server vNext you can create CCI on tables with NVARCHAR(MAX) columns. Since JSON is stored as NVARCHAR type, now you can store huge volumes of JSON ... continue reading
tpch-json

JSON data in clustered column store indexes

Clustered column store indexes (CCI) in SQL Server vNext and Azure SQL Database support LOB types like NVARCHAR(MAX), which allows you to store string with any size, including JSON documents with any size. With CCI you can get 3x compression ... continue reading

Columnstore Index Performance: SQL Server 2016 – Multiple Aggregates

SQL product team has made significant improvements in columnstore index functionality, supportability and performance during SQL Server 2016 based on the feedback from customers. This blog series focuses on the performance improvements done as part of SQL Server 2016. Customers ... continue reading

Columnstore Index Performance: Batch Mode Execution

Just posted the following blog as part of SQL Tiger team blog. I will continue with this series with many other performance specific changes done in SQL Server 2016 Columnstore index Performance: BatchMode Execution Thanks Sunil Agarwal ... continue reading

Columnstore Index Performance: Rowgroup Elimination

Columnstore Index Performance: Rowgroup Elimination Thanks Sunil Agarwal SQL Server Tiger Team ... continue reading
Loading...