Products
Overview
View All Products
Monitoring Features
SentryOne Cloud
Database Monitoring
SQL Sentry
SentryOne Monitor
DW Sentry
DataOps
Task Factory
DOC xPress
SentryOne Document
BI xPress
DBA xPress
SentryOne Test
DTS xChange
Cloud Migration
SentryOne CloudLifter
Free Tools
Plan Explorer
CodeSlice
Solutions
By Role
DBAs
IT Managers
Developers
BI Pros
Leaders
Monitoring
SQL Server
Azure SQL Database
SSAS
VMware
Windows Hyper-V
DataOps
Overview
Data Integration
Documentation
Data Lineage Analysis
Data Testing
Cloud Migration
Overview
AWS
Azure
How To Buy
Download Free Trials
Schedule Demo
Request Quote
Product Pricing
SentryOne Resellers
Resources
Blog
Webinars
Events
Resource Library
Popular Topics
SQL Sentry ROI Calculator
SQLPerformance.com
Support
Documentation
Support Overview
Submit a Support Case
Support Community
Pro Services
Product Renewal
Partners
Overview
Find a Partner
Partner Portal Login
About
Overview
Our Team
Our News
Locations
Careers
My Account
Blog Home
SentryOne Newsletter
Authors
Categories
Category: Transact-SQL
Can ColumnStore Help Pagination Workloads?
Aaron Bertrand revisits whether or not ColumnStore can help pagination workloads.
January 15, 2016
|
SQLPerformance.com
|
Execution Plans
,
T-SQL
,
Transact-SQL
,
ColumnStore
0
A SQL _VARIANT Use Case (No Pun Intended)
Aaron Bertrand uses a T-SQL Tuesday theme to demonstrate a use case for the SQL_VARIANT data type that you may not have considered: Conditional ORDER BY.
August 12, 2014
|
Aaron Bertrand
|
SQLFamily
,
T-SQL
,
Transact-SQL
1
Aaron Bertrand : Dirty Secrets of the CASE Expression
Aaron Bertrand of SQL Sentry takes a look at some unexpected behavior with CASE expression.
June 12, 2014
|
SQLPerformance.com
|
T-SQL
,
SQL Server
,
Transact-SQL
0
Top Categories
SQL Server
(209)
SQL Sentry
(149)
Community
(147)
T-SQL
(127)
SentryOne
(105)
Execution Plans
(66)
SQLFamily
(63)
Monitoring
(60)
Azure
(57)
Plan Explorer
(54)
SQL Server 2016
(51)
Performance Analysis
(50)
Performance
(47)
T-SQL Tuesday
(47)
Cloud
(46)
Career
(41)
Alerting
(39)
Advisory Conditions
(38)
Query Plan Analysis
(34)
System Configuration
(34)
SQLVacation
(31)
PASS Summit
(30)
SQLSaturday
(28)
Azure SQL Database
(27)
PASS
(26)
Security
(23)
Virtualization
(22)
#BackToBasics
(21)
Event Calendar
(19)
Professional Development
(18)
SentryOne Builds
(18)
Statistics
(18)
Best Practices
(17)
SQL Server Builds
(17)
Slide Decks
(17)
Wait Stats
(17)
Global Partner Network
(16)
I/O
(15)
Data Lineage
(14)
DevOps
(14)
Engineering
(14)
Events
(14)
PowerShell
(14)
Custom Conditions
(12)
Documentation
(12)
Indexes
(12)
Extended Events
(11)
SSAS
(11)
Support
(11)
Windows
(11)
AWS
(10)
CPU Performance
(10)
Data Mining
(10)
PowerBI
(10)
Bad Habits
(9)
Fragmentation
(9)
Migration
(9)
SQLBits
(9)
Tips and Tricks
(9)
Analysis Services
(8)
Baselines
(8)
Data Compression
(8)
Database Documentation
(8)
Disk Performance
(8)
Management Studio
(8)
Performance Monitoring
(8)
SQL Server 2014
(8)
SQL Server 2019
(8)
Task Factory
(8)
Tech Outbound
(8)
tempdb
(8)
Database Performance
(7)
Hardware
(7)
Memory Limits
(7)
Reporting
(7)
SQL Server Agent
(7)
SQL Server on Linux
(7)
SQLintersection
(7)
SSIS
(7)
SSMS
(7)
SentryOne Document
(7)
#entrylevel
(6)
ColumnStore
(6)
DataOps
(6)
Optimizer
(6)
SQL Server 2017
(6)
SentryOne Test
(6)
Speaking
(6)
Trace
(6)
Automation
(5)
Customer Success
(5)
Disaster Recovery
(5)
In-Memory OLTP
(5)
Licensing
(5)
Machine Learning
(5)
Microsoft
(5)
Partner Spotlight
(5)
SQL Sentry Essentials
(5)
SQL Server Training
(5)
SQLCruise
(5)
SQLPASS
(5)
Service Packs
(5)
Ship Shape Challenge
(5)
Standard Edition
(5)
Table Variables
(5)
Testing
(5)
Training
(5)
Agile
(4)
Availability Groups
(4)
Azure Data Factory
(4)
Compliance
(4)
Connect
(4)
Deadlocks
(4)
EHO
(4)
GDPR
(4)
Hyper-V
(4)
Installation
(4)
Managed Instances
(4)
Query Store
(4)
SQL Server 2012
(4)
SSRS
(4)
Securing Azure SQL Database
(4)
Storage Forecasting
(4)
Transaction Log
(4)
Troubleshooting
(4)
Women in Technology
(4)
Agile at Home
(3)
AlwaysOn
(3)
Amazon RDS
(3)
Backups
(3)
CTPs
(3)
Cumulative Updates
(3)
DTU Calculator
(3)
Data Testing and Validation
(3)
Demos
(3)
ETL
(3)
Evaluating
(3)
Event Chains
(3)
MSP
(3)
Multi-Tenancy with SQL Server
(3)
SQL Monitoring
(3)
STRING_SPLIT
(3)
SentryOne Portal
(3)
Storage
(3)
Transact-SQL
(3)
Upgrade
(3)
User Guide
(3)
VMware
(3)
Visual Studio
(3)
Webinar
(3)
.NET
(2)
11.2
(2)
4K
(2)
Azure Data Studio
(2)
Cardinality
(2)
DOC xPress
(2)
Data Trends
(2)
Delayed Durability
(2)
Developer Edition
(2)
Docker
(2)
HTAP
(2)
Key Lookups
(2)
News
(2)
Open Source
(2)
Partitioning
(2)
Pragmatic Works Software
(2)
Python
(2)
Reflection
(2)
SQLskills
(2)
Sabin IO
(2)
SentryOne Cloud Sync
(2)
SentryOne Docs
(2)
SentryOne EMEA
(2)
Server Health
(2)
UDFs
(2)
Volunteering
(2)
Wildcard
(2)
Azure DevOps
(1)
Azure Table Storage
(1)
Blocking
(1)
CodeStock
(1)
DB Sentry
(1)
DBA xPress
(1)
DEVELOPMENT
(1)
Dash
(1)
Data Dictionary
(1)
Data Platform
(1)
Data Pros of Tomorrow Scholarship
(1)
Data and Schema Comparison
(1)
Environment Map
(1)
Personal Development
(1)
Problem Solving
(1)
Process Improvement
(1)
Product Samples
(1)
Republic Bank
(1)
SQL Sentry Premium
(1)
SSDs
(1)
SentryOne Ambassadors
(1)
SentryOne Database
(1)
Tableau
(1)
Tabular
(1)
Triggers
(1)
perfmon
(1)
See all
Get the best SQL query analysis and optimization tool –
free!
Index Analysis Sandbox
Statistics Analysis with Histogram
Management Studio Add-in
Plan Diagram
Deadlocks
History and Comments