T-SQL script to Backup database SQL Server with TimeStamp
Callum The T-SQL script takes a full backup of all databases(System databases and user databases) in...
Callum
Get a list of installed SQL Server Components with SQL Server Discovery Tool
Usually, DBA needs to check the SQL Server and find out the answer to the...
Install SQL Server 2022 on Windows
Microsoft announced a private preview of SQL Server 2022 last fall at ignite. SQL Server...
Explain the difference between CHECKPOINT and LAZY Writer in SQL Server
In SQL Server, the checkpoint and lazy writer mechanisms play crucial roles in data durability,...
Explore WITH(NOLOCK)and the difference between NOLOCK and WITH(NOLOCK)SQL Server Table hint
SQL Server Table hints(NOLOCK) help override the default behavior of the query optimizer during the...
PowerShell Script to restart SQL Services
This article gives PowerShell script to restart the SQL Server service, SQL Server Agent, Reporting...
T-SQL query to check SQL Server min server memory(MB) and max server memory(MB)
As per best practice, you must set SQL Server min and max server memory(MB) as...
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...