Great minds discuss ideas!
Introduction As a database administrator (DBA), one of the key responsibilities is to ensure optimal performance and efficient management of database indexes. Index fragmentation can significantly impact query performance and overall database efficiency. In this blog post, we will explore…
Scenario SQL Server error logs are logs that store important information about events, warnings, and errors encountered by the SQL Server instance. These logs act as a valuable source of diagnostic data, assisting administrators and developers in identifying and resolving…
Scenario If you’re facing issues with TempDB in SQL Server, particularly with certain MDF files growing while others remain unaffected, it could indicate a problem with the allocation of database objects within TempDB. Here are a few steps you can…
Introduction In SQL Server, views provide a convenient way to encapsulate complex queries and present a simplified and abstracted representation of data to users. However, there may be situations where you want to grant SELECT permissions on a view while…
Scenario During an upgrade from SQL Server 2008 R2 to SQL Server 2016 SP2, we have noticed that all system databases, except for the master database, are automatically assigned the new compatibility level (130). In this article, we will explore…
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…