Posted in Admin

how to take performance counters in SQL table or Flat Files using Command Prompt

Introduction: In this post, We will use TYPEPERF command prompt utility to capture the perfmon counters. Demo: Capture performance counters in to SQL Tables: You…

Continue Reading... how to take performance counters in SQL table or Flat Files using Command Prompt
Posted in Admin

How to create ODBC connection

Press Windows+R and type odbcad32 then hit enter. It will open below window. Click On Add Select SQL Server and click Finish. It will open…

Continue Reading... How to create ODBC connection
Posted in Admin

Ghost Records and Trace flag 661

Ghost Records: Ghost records are the records that just have been deleted. SQL do not directly delete the records from Index pages but it mark…

Continue Reading... Ghost Records and Trace flag 661
Posted in Admin

How Creating,Dropping or Rebuilding Cluster Index or Heap affect Non clustered Indexes

Introduction: In this post, We will check the effect of creating, dropping or rebuilding clustered index or Heap on non clustered indexes on the same…

Continue Reading... How Creating,Dropping or Rebuilding Cluster Index or Heap affect Non clustered Indexes