top of page

Search
Find Missing Indexes using Query Store
SELECT SUM (qrs.count_executions) *  AVG (qrs.avg_logical_io_reads) as  est_logical_reads, SUM (qrs.count_executions) AS...
Kunal Ranpura
May 291 min read
Â
Â
Â
SQL Server Find Missing Index using Query Store
--Query to find missing index from query store, from last 30days usage SELECT TOP 20 qsq.query_id, SUM(qrs.count_executions) *...
Kunal Ranpura
Mar 311 min read
Â
Â
Â
SQL Server Profiler Trace
--Import multiple trace file in sql Table. --All the rollover files will be automatically imported --provide number tracefile to capture...
Kunal Ranpura
Feb 19, 20241 min read
Â
Â
Â
SQL Replication Mark Transaction as commit
--SQL Server Database log full due to replication, you can run the following command to mark all ---the replication transaction is done,...
Kunal Ranpura
Feb 5, 20241 min read
Â
Â
Â
bottom of page





