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.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
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.
Copy Data from One Table to Another in SQL Server: SQL in Sixty Seconds #031
To copy data from one table to another, use INSERT…SELECT for an existing table or SELECT…INTO for a new one. The tests here show what SELECT…INTO carries over and what it drops, the errors you can hit, and a quick way to check the copy.
SQL SERVER – UNION ALL and ORDER BY – How to Order Table Separately While Using UNION ALL
Two ORDER BY clauses in a UNION ALL give Msg 156. Here is how to use UNION ALL and ORDER BY together to sort the top and bottom sets separately.
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.
SQL SERVER – Storing Variable Values in Temporary Array or Temporary List
SQL Server has no arrays, but simple needs do not call for clever tricks. I use a table variable as a temporary array or list, with a SQL Server 2012 example.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.