Script check the index fragmentation in SQL Server
Today I had a need to find the index fragmentation on one of my sql server database and I found...
SQL Server Replication status
Few days back I had to query to my production sql replication server to find what all publications are running...
Find SSRS reports that are run
WITH RankedReports AS (SELECT ReportID, TimeStart, UserName, RANK() OVER (PARTITION BY ReportID ORDER BY TimeStart DESC) AS iRank FROM dbo.ExecutionLog...
List file groups and indexes for each tables
This is one of those quick tips and trick posts I do once in a while. Â If you ever want...
Encrypting SQL Server Columns
If you have been working with databases long with large company you would have definitely encountered a requirement to encrypt...
How to find total number of read/write on sql server databases
The following SQL will tell you  how many reads and writes the databases on your sql server instances has serviced...