Sometimes you need to update or delete records based on matching records in another table. You may use sub-query for this but there is a better approach by using Joins in your update and delete statements. Following is an exampleMore…

As a developer or DBA, we write T-SQL queries all the time. We should always make sure that our queries are optimized for better performance. Query performance is measured by looking at the query execution time. In this blog, IMore…