Map foreign key chains from a parent table with a recursive catalog query, then list deepest children first and flag cascade rules.
SQL SERVER – Function to Round Up Time to Nearest Minute Interval
A small T-SQL function that rounds a datetime up or down to the nearest minute interval you pass in, with the code and how to call it.
Identity Overflow Check: How Close Is Each INT Column to 2,147,483,647
A table with few rows can still be one insert away from error 8115. Here is a check that shows the real headroom of every INT identity column.
Finding the Error Log Folder and Other Paths From T-SQL
Pasted a server path into File Explorer and found nothing? The folder is on the server, not your laptop. Here are the queries that tell you where.
SQL SERVER – Move Database Files MDF and LDF to Another Location
Your new database sits in the default location and keeps growing. Here is how to move the MDF and LDF database files to another disk or drive.
Gapless Invoice Numbers That Restart Every Year
Finance hates a missing invoice number. A small counter table and one short transaction keep the numbers gapless and restart them each year.
SQL SERVER – Order By Numeric Values Formatted as String
A column holds alphanumeric values that start with a number, and ORDER BY sorts them as text. Here is how to sort the rows by the Numeric part instead.