Joins vs. Exists vs. IN: Not all filters are created the same.
Not all filter commands are created equal. Different filtering operations should be used at different times to get the best performance our of your SQL Server.
New Article: SQL Server tempdb best practices increase performance
I’ve recently published a new tip on SearchSQLServer.com called “SQL Server tempdb best practices increase performance“. Denny
Back To Basics: The INSERT Statement
While the SELECT statement is probably the most important command, the INSERT comes in handy. The INSERT statement is used to do exactly what it sounds like, it inserts data into a table.
I had a great time speaking at the San Diego SQL User Group
I’d like to thank the San Diego SQL Server User Group for having me come and speak to them tonight. I had a great time presenting both my SQL Server Query Tuning and SQL Server Service Broker presentations.