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.
SQL SERVER – Example of Width Sensitive and Width Insensitive Collation
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.
SQL SERVER – Remove Debug Button in SSMS – SQL in Sixty Seconds #020 – Video
The SSMS debug button sits next to Execute and looks like a play button, so people click it by mistake. This short video shows how to remove it.
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.
SQL SERVER – Monday Morning Puzzle – Query Returns Results Sometimes but Not Always
A beginner asked why a query returns results sometimes but not always. I share where I would start looking and invite you to add your own answer.