Category: MSSQL

Introduction SQL Server jobs are essential for automating tasks and maintaining the stability and efficiency of a SQL Server system. These jobs can be scheduled to run at specific times to perform various operations. In this blog post, we will…

This code is designed to provide information about the indexes in the database, including their creation dates, last usage dates, and whether they have been used recently. TSQL — Create a temporary table to store index information CREATE TABLE #IndexInfo…

To use ProcDump to capture a SQL Server unexpected crash dump, follow these steps: Download and extract ProcDump: Navigate to the directory where ProcDump is located: Capture the SQL Server crash dump: Replace C:\Dumps with the desired path and filename…

One day, we suddenly discovered that the SQL Server was not running and was in a stopped state. In a rush, we quickly enabled the SQL Server and Agent services to get them running again.Afterward, we began investigating the reason…

To determine index fragmentation in SQL Server, you can use the following steps: SELECT OBJECT_NAME(DMV.object_id) AS TABLE_NAME , SI.NAME AS INDEX_NAME , avg_fragmentation_in_percent AS FRAGMENT_PERCENT , DMV.record_count FROM sys.dm_db_index_physical_stats(DB_ID(), NULL, NULL, NULL, ‘SAMPLED’) AS DMV LEFT OUTER JOIN SYS.INDEXES AS…

As a SQL DBA, there are various essential tasks to perform every day to ensure the smooth operation and security of the database system. These responsibilities include:

What is the use of DBCC commands?  DBCC stands for Database Console Commands, a few of us also call it database consistency checker. There are many DBCC commands in SQL Server. We generally use these commands to check the consistency of the…

Description This script generates a list of Logins, Users and the Database Roles that the user belongs to in all the databases in A SQL Server; with a couple of other useful information detailed below. Other benefit: you can use…

In a SQL Server environment, it can be useful to monitor the user activity and track who is connected to the databases, from which machine they are connected, when they connected and what application they are running. In this blog,…