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 (192)
- Community (129)
- SQL Sentry (128)
- T-SQL (125)
- SentryOne (83)
- Execution Plans (66)
- SQLFamily (61)
- Monitoring (59)
- Azure (51)
- Plan Explorer (51)
- SQL Server 2016 (51)
- Performance (47)
- Performance Analysis (47)
- T-SQL Tuesday (45)
- Cloud (44)
- Career (36)
- Query Plan Analysis (33)
- System Configuration (33)
- Alerting (31)
- SQLVacation (31)
- Advisory Conditions (29)
- PASS Summit (29)
- SQLSaturday (28)
- PASS (25)
- Azure SQL Database (22)
- #BackToBasics (21)
- Virtualization (21)
- Event Calendar (19)
- SentryOne Builds (18)
- Statistics (18)
- SQL Server Builds (17)
- Slide Decks (17)
- Wait Stats (17)
- Global Partner Network (16)
- I/O (15)
- Best Practices (14)
- Security (14)
- PowerShell (13)
- Custom Conditions (12)
- DevOps (11)
- Engineering (11)
- CPU Performance (10)
- Extended Events (10)
- Indexes (10)
- PowerBI (10)
- Support (10)
- Windows (10)
- Bad Habits (9)
- Events (9)
- Fragmentation (9)
- SQLBits (9)
- SSAS (9)
- Analysis Services (8)
- Baselines (8)
- Data Compression (8)
- Data Mining (8)
- Disk Performance (8)
- Management Studio (8)
- SQL Server 2014 (8)
- SQL Server 2019 (8)
- Tech Outbound (8)
- Tips and Tricks (8)
- Hardware (7)
- Memory Limits (7)
- Reporting (7)
- SQLintersection (7)
- SSIS (7)
- SSMS (7)
- #entrylevel (6)
- AWS (6)
- ColumnStore (6)
- Data Lineage (6)
- Documentation (6)
- Optimizer (6)
- SQL Server 2017 (6)
- SQL Server Agent (6)
- SentryOne Test (6)
- Speaking (6)
- Task Factory (6)
- tempdb (6)
- Automation (5)
- Customer Success (5)
- In-Memory OLTP (5)
- Machine Learning (5)
- Microsoft (5)
- Migration (5)
- Partner Spotlight (5)
- Performance Monitoring (5)
- Professional Development (5)
- SQL Server Training (5)
- SQLCruise (5)
- Service Packs (5)
- Ship Shape Challenge (5)
- Standard Edition (5)
- Testing (5)
- Trace (5)
- Availability Groups (4)
- Connect (4)
- Database Documentation (4)
- Database Performance (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)
- Table Variables (4)
- Training (4)
- Transaction Log (4)
- Troubleshooting (4)
- Women in Technology (4)
- AlwaysOn (3)
- Azure Data Factory (3)
- CTPs (3)
- Cumulative Updates (3)
- DTU Calculator (3)
- Data Testing and Validation (3)
- Demos (3)
- Disaster Recovery (3)
- ETL (3)
- Event Chains (3)
- MSP (3)
- STRING_SPLIT (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)
- DOC xPress (2)
- Data Trends (2)
- DataOps (2)
- Deadlocks (2)
- Delayed Durability (2)
- Developer Edition (2)
- Evaluating (2)
- HTAP (2)
- Key Lookups (2)
- Partitioning (2)
- Pragmatic Works Software (2)
- Reflection (2)
- SQL Monitoring (2)
- SQLskills (2)
- Sabin IO (2)
- SentryOne Cloud Sync (2)
- SentryOne Docs (2)
- SentryOne EMEA (2)
- SentryOne Portal (2)
- Server Health (2)
- Storage (2)
- UDFs (2)
- Upgrade (2)
- Volunteering (2)
- Wildcard (2)
- CodeStock (1)
- DB Sentry (1)
- DBA xPress (1)
- DEVELOPMENT (1)
- Data Platform (1)
- Data and Schema Comparison (1)
- Docker (1)
- Open Source (1)
- Product Samples (1)
- Republic Bank (1)
- SSDs (1)
- SentryOne Database (1)
- Tableau (1)
- Tabular (1)
- Triggers (1)
- UpSearch (1)
- perfmon (1)
