Many readers struggled with my blog post on this, so here it is as a video: a SQL Server Management Studio shortcut to select single row from any table.
SQL SERVER – Avoid Using Function in WHERE Clause – Scan to Seek
Does a function in WHERE clause really hurt performance? Using AdventureWorks and STATISTICS IO, I show what happens and how to turn a scan into a seek.
How to Add Column at Specific Position in SQL Server
To add column at specific position in SQL Server, you have three tested options, because ALTER TABLE always adds the column last. This post shows a SELECT list, a view for loads and reports, and a full table rebuild. It also explains what the rebuild costs.
BACPAC or Backup: When an Export Is the Wrong Tool
A BACPAC export has rows in it, but it is not a recovery backup. Here is a small demo that shows the difference.
Finding Procedures Created With the Wrong SET Options
Find procedures with wrong SET options in sys.sql_modules, understand error 1934, and recreate modules with ANSI_NULLS and QUOTED_IDENTIFIER ON.
SQL SERVER – Tricky Question – What is the Default Size of the Database
What is the default size of the database in SQL Server? Many guess 3 MB or 4 MB, but the real answer depends on the model system database.
SQL SERVER – Check If String is a Palindrome in Using T-SQL Script – Reverse Function
A friend building a captcha had to skip words that read the same backward. Here is a T-SQL script with REVERSE to check if a string is a Palindrome.