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 (209)
- SQL Sentry (153)
- Community (147)
- T-SQL (127)
- SentryOne (105)
- Execution Plans (66)
- SQLFamily (63)
- Monitoring (61)
- Azure (58)
- Plan Explorer (54)
- SQL Server 2016 (51)
- Performance Analysis (50)
- Performance (47)
- T-SQL Tuesday (47)
- Cloud (46)
- Career (41)
- Advisory Conditions (39)
- Alerting (39)
- Query Plan Analysis (34)
- System Configuration (34)
- SQLVacation (31)
- PASS Summit (30)
- Azure SQL Database (28)
- SQLSaturday (28)
- PASS (26)
- Security (23)
- Professional Development (22)
- Virtualization (22)
- #BackToBasics (21)
- Event Calendar (20)
- SentryOne Builds (18)
- Statistics (18)
- Best Practices (17)
- SQL Server Builds (17)
- Slide Decks (17)
- Wait Stats (17)
- Events (16)
- Global Partner Network (16)
- I/O (15)
- Data Lineage (14)
- DevOps (14)
- Engineering (14)
- PowerShell (14)
- Documentation (13)
- Custom Conditions (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)
- SentryOne Document (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)
- #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)
- EHO (5)
- In-Memory OLTP (5)
- Licensing (5)
- Machine Learning (5)
- Microsoft (5)
- Partner Spotlight (5)
- SQL Server Training (5)
- SQLCruise (5)
- SQLPASS (5)
- Securing Azure SQL Database (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)
- GDPR (4)
- Hyper-V (4)
- Installation (4)
- Managed Instances (4)
- Query Store (4)
- SQL Sentry Essentials (4)
- SQL Server 2012 (4)
- SSRS (4)
- SentryOne Portal (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)
- Server Health (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)
- 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)
