In SQL Server Management Studio, it is possible to execute a multi server query against several … Multi Server QueryRead more
Tips & Tricks
Large Inserts and count(*)
If you insert lots of rows into a table with a clustered index, a SELECT COUNT(*) … Large Inserts and count(*)Read more
Line numbers in t-sql error messages
When you run scripts in SSMS and get an error, the error references a line number … Line numbers in t-sql error messagesRead 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