Aaron Bertrand shows how to implement simple triggers that maintain trigram-type tables used for better supporting wildcard searches.
Category: Wildcard
In an effort to make leading wildcard searches sargable, Aaron Bertrand plays around with a trigram-type implementation in SQL Server.
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)
