
Tag: TSQL


The Simplest Alternative to sp_MSforeachdb

Finding a use for Extended Properties in SQL Server

Even more fun with DATETIME arithmetics!

Fun with DATETIME Arithmetics

T-SQL Tuesday #136 – Most and Least Favorite Data Type

T-SQL Tuesday #131 – Star Trek Candy and SWITCH TO

The new “metadata-only column changes” feature in SQL Server 2016 is useless!

Using SUBSTRING based on line number instead of character offset
