Using DBCC CLONEDATABASE and Query Store for Testing Erin Stellato demonstrates how to use the new DBCC CLONEDATABASE feature, in combination with Query Store, to test index and query changes. Erin Stellato ◆ February 22, 2017 6
Using AT TIME ZONE to fix an old report Rob Farley (@rob_farley) contributes to T-SQL Tuesday #87, showing how he would use AT TIME ZONE to simplify reports based on an end user's time zone. Rob Farley ◆ February 14, 2017 1
Follow-up #1 on leading wildcard seeks Aaron Bertrand (@AaronBertrand) shows how to implement simple triggers that maintain trigram-type tables used for better supporting wildcard searches. Aaron Bertrand ◆ February 8, 2017 12
One way to get an index seek for a leading %wildcard In an effort to make leading wildcard searches sargable, Aaron Bertrand (@AaronBertrand) plays around with a trigram-type implementation in SQL Server. Aaron Bertrand ◆ February 3, 2017 32
