Decide whether shrinking database good or bad advice fits your case, inspect fragmentation, and use low-priority shrink cautiously.
SQL SERVER – What are the Different Ways to Script Procedure with T-SQL
What are the different ways to script procedure code with T-SQL? There are four, including sp_helptext and INFORMATION_SCHEMA.ROUTINES. Here is each one.
SQL SERVER – One Trick of Handling Dynamic SQL to Avoid SQL Injection Attack?
SQL Injection is not a SQL Server problem, it comes from coding habits. Here is one trick of handling dynamic SQL to avoid SQL injection attack on a search page.
SQL SERVER – Invoking a Stored Procedure from Azure Mobile Services – Notes from the Field #066
Can you call a SQL stored procedure from Azure Mobile Services? In Notes from the Field #066, Kevin Hazzard shows how, with a bit of humor along the way.
SQL SERVER – Script – When/Who did Auto Grow for the Database?
A reader saw the database file grow every day with very few users. Here is a script to find when auto grow happened for a database and who triggered it.
SQL SERVER – How Can Deadlock Happen on Same Table?
How can deadlock happen on same table? A World Chess Championship match inspired this post, where I walk through how two sessions can block each other.
Interview Question of the Week #005 – List All the Tables with Name Containing Specific String
Find SQL Server tables whose names contain a specific string, handle literal underscores, and include schemas without a date filter.
Reads per Execution: Ranking Queries by Average I/O
The query with the most total reads is not always the one to tune first. Here is how to rank by cost per call and read the spread.










