Back To Basics: The UPDATE Statement
After you’ve inserted the data into the table, it’s time to update the data. We do this by using the UPDATE statement.
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.