Query performance depends on database table indexes—learn why and see how index maintenance works.
Frank Solomon
Frank Solomon is an ActualTech Media Contributor and an expert in building software and technical writing resources.
Articles by Frank Solomon
Top Categories
- SQL Server (229)
- SQL Sentry (156)
- Community (147)
- T-SQL (133)
- SentryOne (105)
- Execution Plans (67)
- Azure (63)
- SQLFamily (63)
- Monitoring (62)
- Plan Explorer (54)
- SQL Server 2016 (51)
- Performance Analysis (50)
- Performance (49)
- Cloud (47)
- T-SQL Tuesday (47)
- Career (41)
- Advisory Conditions (40)
- Alerting (39)
- Query Plan Analysis (34)
- System Configuration (34)
- Best Practices (33)
- Azure SQL Database (31)
- SQLVacation (31)
- PASS Summit (30)
- SQLSaturday (28)
- PASS (26)
- Security (24)
- Professional Development (22)
- Virtualization (22)
- #BackToBasics (21)
- Event Calendar (20)
- SentryOne Builds (18)
- Statistics (18)
- SQL Server Builds (17)
- Slide Decks (17)
- Wait Stats (17)
- DevOps (16)
- Documentation (16)
- Events (16)
- Global Partner Network (16)
- Indexes (16)
- Data Lineage (15)
- I/O (15)
- Engineering (14)
- PowerShell (14)
- Custom Conditions (12)
- Database Documentation (11)
- Extended Events (11)
- SSAS (11)
- Support (11)
- Windows (11)
- AWS (10)
- CPU Performance (10)
- Data Mining (10)
- Database Mapper (10)
- Database Performance (10)
- Fragmentation (10)
- Migration (10)
- PowerBI (10)
- Tips and Tricks (10)
- Bad Habits (9)
- SQLBits (9)
- Analysis Services (8)
- Baselines (8)
- Data Compression (8)
- DataOps (8)
- Disk Performance (8)
- Management Studio (8)
- Performance Monitoring (8)
- SQL Server 2014 (8)
- SQL Server 2019 (8)
- SSIS (8)
- Task Factory (8)
- Tech Outbound (8)
- tempdb (8)
- Disaster Recovery (7)
- Hardware (7)
- Memory Limits (7)
- Reporting (7)
- SQL Server Agent (7)
- SQL Server on Linux (7)
- SQLintersection (7)
- SSMS (7)
- #entrylevel (6)
- Backups (6)
- ColumnStore (6)
- Microsoft (6)
- Optimizer (6)
- SQL Server 2017 (6)
- SQL Server Training (6)
- SentryOne Test (6)
- Speaking (6)
- Trace (6)
- AlwaysOn (5)
- Automation (5)
- Availability Groups (5)
- Customer Success (5)
- EHO (5)
- ETL (5)
- In-Memory OLTP (5)
- Licensing (5)
- Machine Learning (5)
- Partner Spotlight (5)
- PostgreSQL (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)
- Azure Data Factory (4)
- Compliance (4)
- Connect (4)
- Deadlocks (4)
- GDPR (4)
- Hyper-V (4)
- Installation (4)
- Managed Instances (4)
- News (4)
- Query Store (4)
- Query Tuning (4)
- SQL Sentry Essentials (4)
- SQL Server 2012 (4)
- SSRS (4)
- SentryOne Portal (4)
- Storage (4)
- Storage Forecasting (4)
- Transaction Log (4)
- Troubleshooting (4)
- Women in Technology (4)
- Agile at Home (3)
- Amazon RDS (3)
- Azure DevOps (3)
- CTPs (3)
- Cumulative Updates (3)
- DTU Calculator (3)
- Data Governance (3)
- Data Testing and Validation (3)
- Demos (3)
- Evaluating (3)
- Event Chains (3)
- MSP (3)
- Multi-Tenancy with SQL Server (3)
- SQL Monitoring (3)
- SQLskills (3)
- STRING_SPLIT (3)
- Server Health (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 Dictionary (2)
- Data Trends (2)
- Delayed Durability (2)
- Developer Edition (2)
- Docker (2)
- Environment Map (2)
- HTAP (2)
- Key Lookups (2)
- Open Source (2)
- Partitioning (2)
- Pragmatic Works Software (2)
- Python (2)
- Reflection (2)
- Sabin IO (2)
- SentryOne Cloud Sync (2)
- SentryOne Docs (2)
- SentryOne EMEA (2)
- UDFs (2)
- Volunteering (2)
- Wildcard (2)
- Azure Table Storage (1)
- Blocking (1)
- CodeStock (1)
- DB Sentry (1)
- DBA xPress (1)
- DEVELOPMENT (1)
- Dash (1)
- Data Platform (1)
- Data Pros of Tomorrow Scholarship (1)
- Data Stewardship (1)
- Data and Schema Comparison (1)
- MAXDOP (1)
- Personal Development (1)
- Problem Solving (1)
- Process Improvement (1)
- Product Samples (1)
- Republic Bank (1)
- SQL Sentry Premium (1)
- SQL Server 2022 (1)
- SSDs (1)
- SentryOne Ambassadors (1)
- SentryOne Database (1)
- Tableau (1)
- Tabular (1)
- Triggers (1)
- how to implement multi tenancy (1)
- how to optimize database performance (1)
- perfmon (1)
- sql database optimization techniques (1)
- what is multi tenancy (1)
