Books Online Consolidation
I explain the ups and downs of a cohesive, consolidated, version-agnostic Books Online for SQL Server.
Monthly Archive: February 2017
Auditing Who Changed Temporal Table Data in SQL Server
Tip : Auditing Who Changed Temporal Table Data in SQL Server
T-SQL Tuesday #87 : Shiny New Toys
For T-SQL Tuesday #87, I talk about two shiny new toys in SQL Server: STRING_SPLIT() and STRING_AGG().
Managing Temporal Table History in SQL Server 2016
Tip : Managing Temporal Table History in SQL Server 2016
Follow-up #1 on leading wildcard seeks
I show how to implement simple triggers that maintain trigram-type tables used for better supporting wildcard searches.
One way to get an index seek for a leading %wildcard
In an effort to make leading wildcard searches sargable, I play around with a trigram-type implementation in SQL Server.