Why does INFORMATION_SCHEMA.COLUMNS show -1 as the character maximum length? A reader asked me this simple question, and I explain what the negative value means.
SQL SERVER – Find Column Used in Stored Procedure – Search Stored Procedure for Column Name – Part 2
Readers improved my script to find column used in stored procedure. Imran Mohammed shares newer scripts to search stored procedure for column name.
Generate Script for Schema and Data in SQL Server: SQL in Sixty Seconds #021
To generate script for schema and data, choose Schema and data in the SSMS wizard and review the result before you run it. The tests here build such a script with T-SQL on SQL Server 2025 and show three ways it breaks: identity columns, apostrophes and the 1,000 row limit.
Decommissioning a Database: A Safe Checklist Before the Drop
Dropping an old database is a one-way door. Here is the short checklist I run first, with a demo you can paste into SSMS.
SQL SERVER – 2012 Functions – FORMAT() and CONCAT() – An Interesting Usage
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+]
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.








![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-600x315.jpg)

