Tag: SQL Server
SQL Server Table Sizes
With Azure SQL, you can’t run the table size reports, so I use this script (as a view) to see the…
Read MoreSQL Server: Convert a date with time to a specific timezone offset
I needed to insert a record into a table with the datetimeoffset with a specific timezone’s offset.
Read MoreHow to Find the Last Time a Table was Updated in SQL Server
Tracking when a table was last updated is a common requirement in database management. It can help with monitoring data activity…
Read MoreShrink a SQL Database
A couple of weeks ago, I had an Azure SQL Database size explode. You can’t run reports that come with SQL…
Read MoreMy Notes: Levenshtein distance and/or Metaphone
aka things that sound alike Levenshtein distance and Metaphone 3 are two different algorithms primarily used in the context of text…
Read More