New Article: Tips for scheduling and testing SQL Server backups
Get expert advice for scheduling backup jobs in SQL Server via SQL Server Agent using a crafted BACKUP DATABASE command or maintenance plan. If you’re using SQL Server Express Edition, you’ll learn how to schedule backups with Microsoft Windows Task Scheduler. This tip also shows you how to test your backups for successful restores and the best method for securing SQL Server backups.
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