All About SQL

Discussing all things around the Microsoft Data Platform

Main menu

Skip to primary content
Skip to secondary content
  • Azure Section
  • SQL Server Section
  • Personal Section
  • SQL Server Central Articles
  • TechNet articles
  • SQL Server Video Library
  • Presentations
  • Get In Touch

Tag Archives: Columnstore

Azure SQL Database and Columnstore Indexes

Posted on April 9, 2018 by blobeater
1

I have come to understand the importance of using columnstore indexes when my queries are aggregating and scanning across many millions of rows.

Continue reading →

Share this:

  • Tweet
  • Print
  • Email
  • WhatsApp

Like this:

Like Loading...
Posted in Azure, Azure SQL DB, SQL SERVER | Tagged Azure, Azure SQL DB, Columnstore, Indexes, TSQL | 1 Reply

Archives

Enter your email address below.

Hot Topics

  • SSMS Keeps Crashing
  • Azure SQL Database vCore
  • SSMS 17 Dark Theme
  • Azure SQL Database – Service Tiers
  • Checking Time Zones in SQL Server
  • My application to Microsoft
  • SQL Server Phantom Reads
  • Always Encrypted Column Encryption
  • Azure: SQL Database Elastic Pool and using Elastic Jobs
  • WinDbg and SQL Server Fun

Categories

  • Azure
    • Always Encrypted
    • Apps
    • Automation
    • Azure DWH
    • Azure PowerShell
    • Azure SQL DB
    • Azure-TDE
    • Cloud Blog Series
    • DMVs
    • Elastic Pool
    • IaaS
    • Migration
    • MySQL
  • BLOBEATER
    • About Me
    • General
    • Personal
    • Training
  • Other
    • DevOps
  • Power BI
  • SQL SERVER
    • Admin
    • Backup & Recovery
    • CHECKDB
    • Corruption
    • DBCC
    • Extended Events
    • General TSQL
    • Indexes
    • memory
    • Performance Dashboard
    • PowerShell
    • QueryStore
    • SQL Server 2016
    • SQL Server 2017
    • SQL Server Video Clips
    • SSMS
    • TDE
    • vNext
    • Waits&Latches
  • T-SQL Tuesday

SQL Server Quick Video Clips

  • Get In Touch
  • Presentations
  • SQL Server Video Library

Follow me on Twitter

My Tweets

Social Media

  • View blobeater1’s profile on Twitter
  • View ASirpal’s profile on LinkedIn
  • View Arun Sirpal’s profile on Google+

Blog Tags

  • 2016
  • About Me
  • adaptive query processing
  • AD Authentication
  • Admin
  • AlwaysEncrypted
  • Apps
  • Automatic Tuning
  • Azure
  • Azure Cloud Shell
  • Azure Portal
  • Azure SQL DB
  • Azure SQL DWH
  • backups
  • BLOBEATER
  • Brent Ozar
  • bytes
  • CHECKDB
  • Cloud
  • Cloud Busting
  • compression
  • Config
  • Corruption
  • costs
  • CPU
  • Databases
  • DBA
  • DBCC CHECKDB
  • DBCC Page
  • DMA
  • DMVs
  • DTU
  • Editions
  • Elastic Pool
  • Encryption
  • Execution plans
  • Extended Events
  • Firewall
  • fn_dump
  • Fragmentation
  • Indexes
  • Install
  • Interleaved Execution
  • Internals
  • Locking
  • Logins
  • lsn
  • memory
  • Microsoft
  • Migration
  • NOLOCK
  • offline
  • Performance Dashboards
  • Personal
  • physloc
  • plan cache
  • Podcasts
  • portal
  • Power BI
  • PowerShell
  • Pricing
  • QueryStore
  • readpast
  • Replication
  • Resources
  • RID
  • Security
  • Shrink
  • SQL
  • SQLBits
  • SQL database
  • SQLDB
  • SQL server
  • SQL Server 2014
  • SQL Server 2016
  • SQL Server 2017
  • SQL Server vNext
  • SQLskills
  • SQL Trace
  • SSMS
  • SSRS
  • StackTrace
  • statistics
  • Storage
  • T-SQL Tuesday
  • Target vs Total
  • task manager
  • TDE
  • Technology
  • Tempdb
  • time zones
  • traceflags
  • Training
  • TSQL
  • TSQL Tuesday
  • Tuning
  • Video
  • vNext
  • waits
  • XQuery

Translate Here!

Blog at WordPress.com.
loading Cancel
Post was not sent - check your email addresses!
Email check failed, please try again
Sorry, your blog cannot share posts by email.
%d bloggers like this: