T-SQL query to change the job owners for all jobs owned by a specific login
Many SQL Server DBAs manage jobs through the SSMS GUI and do not know about the underlying T-SQL scripts being...
Author: Callum
Callum is a news writer at DBBlogger, delivering timely updates and concise analysis across a range of global and digital topics.
234 articles
SQL SERVER script to get Database Backup History
Here is a SQL Server script that will get you the database backup history for a server. It is a...
Type conversion in expression may affect “Cardinality Estimate” in querY plan choice
This blog post is about the conversion between implicit and explicit conversion within SQL Server. Introduction The query performance issues...
Key (Lookup) in SQL Server Key Lookup performance
Learn about SQL Server key lookup performance and how to improve the performance of key lookup queries. One of the...
Round up or Round down in SQL Server
SQL Server has a built-in function to round numbers up or down. Learn how to use this function to round...
Steps to add Add Identity Column to Table in SQL Server
The identity column uniquely identifies a row in SQL Server. You can have only one identity column per table. Define...
Steps to troubleshoot high CPU utilization in SQL Server
This article describes the steps to troubleshoot high CPU utilization in SQL Server. If you are experiencing high CPU utilization...
Error while SQL Server Service Pack or Cumulative Updates: “Cached MSI file is missing”
Are you getting the following Cached MSI file missing error (Error Code 0x84B20002) while trying to do SQL Server Service...
Different ways to check the last Restart time of SQL Server
Knowing when your SQL Server instance was last started can be helpful for various reasons. In this tip, we will...
SQL Server Performance Tuning – Index Scan vs. Index Seek
SQL Server performance tuning has always been a tricky task. It is especially true when you’re using indexes. With clustered...