Month: January 2018
Posted in Admin
how to take performance counters in SQL table or Flat Files using Command Prompt
Author: Sauras Pandey Published Date: January 4, 2018 1 Comment on 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…
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…
Posted in Admin
Ghost Records and Trace flag 661
Author: Sauras Pandey Published Date: January 3, 2018 Leave a Comment on 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…
Posted in Admin
How Creating,Dropping or Rebuilding Cluster Index or Heap affect Non clustered Indexes
Author: Sauras Pandey Published Date: January 1, 2018 2 Comments on 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…