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 following questions: What’s components are...
Category: Others
117 articles
Install SQL Server 2022 on Windows
Microsoft announced a private preview of SQL Server 2022 last fall at ignite. SQL Server 2022 is the latest offering...
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, recovery, and overall system performance....
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 SQL query execution. It is...
PowerShell Script to restart SQL Services
This article gives PowerShell script to restart the SQL Server service, SQL Server Agent, Reporting Service (SSRS), and SQL Server...
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 post-installation steps. SQL Server 2019...
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 ID format. Let’s say you...
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 queries you can run to...
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 find the culprit...
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 one of the replicas for...