SQL Server: When records lock, use %%lockres%% to find the page information of records

I shared a couple of articles on SQL Server database locking and how to detect a deadlock. Please access few of them. Different ways to detect a deadlock What happens after the Deadlock? I recently found an undocumented function %%lockres%% which we can use to locate the page information of records especially for those records […]

March 4, 2017 SQL Server

March 3, 2017

SQL Server: How to SELECT Random records from a Table?

March 2, 2017

PostgreSQL: Shell script to copy table data from one server to another server

March 1, 2017

PostgreSQL: Shell script to store psql SELECT output into Variable

February 28, 2017

PostgreSQL: Shell script to store psql result in RECORD ARRAY using WHILE LOOP

February 27, 2017

SQL Server: Execute CHECKPOINT and SHUTDOWN your Database Server immediately

February 26, 2017

SQL Server: Create index on large Temp Tables

February 25, 2017

SQL Server: Script to find bad Sessions or Processes

February 24, 2017

SQL Server: Script to find Open Connections and CPU Usage of each Client Programs

February 23, 2017

SQL Server 2016: Create a FOREIGN KEY in Memory optimized Table (In-Memory OLTP)

Older posts Newer posts

About Me!