T-SQL query to check SQL Server min server memory(MB) and max server memory(MB)
Callum As per best practice, you must set SQL Server min and max server memory(MB) as...
Callum
Identifying SQL Agent Job from the format – SQLAgent – TSQL JobStep (Job 0xC4A075BBC7D7FB4993E60371
This article helps you get the SQL Server agent job name from the hexadecimal Job...
SQL Server Queries to troubleshoot Memory pressure on SQL instance
SQL Server memory pressure can cause a lot of problems. This is a list of...
Why my SQL Server tempdb database Is Growing Fast?
Have you ever wondered why your tempdb database is growing so fast? This article explores...
How to Suspend and Resume an Availability Database in SQL Server Always On Availability Group
One of the fantastic features of Always On Availability Groups is that you can take...
Identify When your SQL Database Was Last Used – SQL Server
Database servers are used for storing vast amounts of data. It is essential to know...
Convert Unix Timestamp in SQL Server (T-SQL)
Want to know how to convert a Unix timestamp to a SQL Server timestamp or...
SQL Server Error VIEW SERVER STATE permission was denied on object ‘server’,databasE’Master’
Did you face the error – VIEW SERVER STATE permission was denied on object ‘server’,...
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...
SQL SERVER script to get Database Backup History
Here is a SQL Server script that will get you the database backup history for...