An interesting way to use the SQL Server 2012 FORMAT() and CONCAT() functions together to show a string like Current Time is Sunday July 16, 2012.
SQL SERVER – Find Column Used in Stored Procedure – Search Stored Procedure for Column Name
Want to drop a column? First find column used in stored procedure code. I share the T-SQL script that searches every stored procedure for a column name.
Width Sensitive and Width Insensitive Collation: An Example
What is a width sensitive collation? I explain it with a simple example that compares half-width and full-width characters under both collation settings.
![SQL SERVER - Switch Between Two Parenthesis using Shortcut CTRL+]](https://blog.sqlauthority.com/wp-content/uploads/covers/sql-server-switch-between-two-parenthesis-using-shortcut-ctrl-cover.jpg)
SQL SERVER – Switch Between Two Parenthesis using Shortcut CTRL+]
A reader shared a handy SSMS tip: press CTRL+] to switch between two parenthesis and jump from an opening bracket to its closing one in long queries.
SQL SERVER – Effect of Case Sensitive Collation on Resultset
A simple example of how a case sensitive collation changes the result of the same query, and why you should not change collation without knowing the business need.
Debug Button in Older SSMS: SQL in Sixty Seconds #020
The Debug button in older SSMS could be mistaken for Execute, and the debugger is gone from current versions. This page keeps the 2012 episode and tests four ways to debug T-SQL without it on SQL Server 2025: parse only, error line numbers, progress messages and the OUTPUT clause.
DATEDIFF Counts Boundaries, Not Time: Getting Durations Right
A report can say one year of service after a single day. Here is why DATEDIFF does that, and what to use instead.