Aaron Bertrand revisits whether or not ColumnStore can help pagination workloads.
Category: Transact-SQL
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.
Aaron Bertrand of SQL Sentry takes a look at some unexpected behavior with CASE expression.
Top Categories
- SQL Server (201)
- Community (140)
- SQL Sentry (131)
- T-SQL (126)
- SentryOne (91)
- Execution Plans (66)
- SQLFamily (63)
- Monitoring (59)
- Azure (54)
- Plan Explorer (54)
- SQL Server 2016 (51)
- Performance (47)
- Performance Analysis (47)
- T-SQL Tuesday (45)
- Cloud (44)
- Career (36)
- Query Plan Analysis (34)
- System Configuration (33)
- Alerting (32)
- SQLVacation (31)
- Advisory Conditions (30)
- PASS Summit (29)
- SQLSaturday (28)
- Azure SQL Database (26)
- PASS (25)
- #BackToBasics (21)
- Virtualization (21)
- Security (20)
- Event Calendar (19)
- SentryOne Builds (18)
- Statistics (18)
- SQL Server Builds (17)
- Slide Decks (17)
- Wait Stats (17)
- Best Practices (16)
- Global Partner Network (16)
- I/O (15)
- PowerShell (14)
- Engineering (13)
- Custom Conditions (12)
- DevOps (12)
- Indexes (12)
- Data Lineage (11)
- Events (11)
- Support (11)
- Windows (11)
- CPU Performance (10)
- Extended Events (10)
- PowerBI (10)
- Bad Habits (9)
- Documentation (9)
- Fragmentation (9)
- SQLBits (9)
- SSAS (9)
- Tips and Tricks (9)
- AWS (8)
- Analysis Services (8)
- Baselines (8)
- Data Compression (8)
- Data Mining (8)
- Database Documentation (8)
- Disk Performance (8)
- Management Studio (8)
- SQL Server 2014 (8)
- SQL Server 2019 (8)
- Task Factory (8)
- Tech Outbound (8)
- Hardware (7)
- Memory Limits (7)
- Migration (7)
- Reporting (7)
- SQLintersection (7)
- SSIS (7)
- SSMS (7)
- tempdb (7)
- #entrylevel (6)
- ColumnStore (6)
- Optimizer (6)
- Professional Development (6)
- SQL Server 2017 (6)
- SQL Server Agent (6)
- SentryOne Test (6)
- Speaking (6)
- Trace (6)
- Automation (5)
- Customer Success (5)
- Database Performance (5)
- In-Memory OLTP (5)
- Machine Learning (5)
- Microsoft (5)
- Partner Spotlight (5)
- Performance Monitoring (5)
- SQL Server Training (5)
- SQLCruise (5)
- Service Packs (5)
- Ship Shape Challenge (5)
- Standard Edition (5)
- Table Variables (5)
- Testing (5)
- Training (5)
- Availability Groups (4)
- Azure Data Factory (4)
- Connect (4)
- DataOps (4)
- Deadlocks (4)
- Disaster Recovery (4)
- EHO (4)
- GDPR (4)
- Hyper-V (4)
- Installation (4)
- Licensing (4)
- Managed Instances (4)
- Query Store (4)
- SQL Sentry Essentials (4)
- SQL Server 2012 (4)
- SQL Server on Linux (4)
- SQLPASS (4)
- SSRS (4)
- Storage Forecasting (4)
- Transaction Log (4)
- Troubleshooting (4)
- Women in Technology (4)
- AlwaysOn (3)
- CTPs (3)
- Cumulative Updates (3)
- DTU Calculator (3)
- Data Testing and Validation (3)
- Demos (3)
- ETL (3)
- Event Chains (3)
- MSP (3)
- SQL Monitoring (3)
- STRING_SPLIT (3)
- Securing Azure SQL Database (3)
- SentryOne Portal (3)
- Storage (3)
- Transact-SQL (3)
- User Guide (3)
- VMware (3)
- Visual Studio (3)
- Webinar (3)
- 11.2 (2)
- 4K (2)
- Amazon RDS (2)
- Azure Data Studio (2)
- Backups (2)
- Cardinality (2)
- Compliance (2)
- DOC xPress (2)
- Data Trends (2)
- Delayed Durability (2)
- Developer Edition (2)
- Evaluating (2)
- HTAP (2)
- Key Lookups (2)
- Partitioning (2)
- Pragmatic Works Software (2)
- Reflection (2)
- SQLskills (2)
- Sabin IO (2)
- SentryOne Cloud Sync (2)
- SentryOne Docs (2)
- SentryOne Document (2)
- SentryOne EMEA (2)
- Server Health (2)
- UDFs (2)
- Upgrade (2)
- Volunteering (2)
- Wildcard (2)
- .NET (1)
- Blocking (1)
- CodeStock (1)
- DB Sentry (1)
- DBA xPress (1)
- DEVELOPMENT (1)
- Data Platform (1)
- Data and Schema Comparison (1)
- Docker (1)
- News (1)
- Open Source (1)
- Product Samples (1)
- Republic Bank (1)
- SSDs (1)
- SentryOne Ambassadors (1)
- SentryOne Database (1)
- Tableau (1)
- Tabular (1)
- Triggers (1)
- perfmon (1)
