When you run scripts in SSMS and get an error, the error references a line number … Line numbers in t-sql error messagesRead more
Day: October 15, 2013
Create or Replace
Blog series: SQL Server Connect Items How many times have you been forced to change a … Create or ReplaceRead more
Rowlock can block more than a row
To avoid the blocking of other users, rowlocks are sometimes used to create locks on the … Rowlock can block more than a rowRead more
Missing comma between columns in select statement
Hopefully, when you make an typing error while writing a SQL statement, you get the red … Missing comma between columns in select statementRead more
Zero footprint Server/Database DDL Trigger
Aaron Bertrand has written a great introduction to server/database DDL triggers in his article SQL Server … Zero footprint Server/Database DDL TriggerRead more