The Daily Dose

The Prescription for SQL Server

May 08

Using EXCEPT and INTERSECT to Validate SQL Server Query Tuning

By Jeffry Schwartz | Query Tuning , SQL Server

This article explains how the EXCEPT and INTERSECT T-SQL operators can help compare query results when tuning SQL Server queries, stored procedures, and views. Recently, a customer requested that I optimize several SSRS financial reports that frequently took between one and three minutes to complete. These reports were driven by complex code involving user-defined functions, […]

Continue reading
Jun 12

Stop Jobs That Run Too Long

By Lori Brown | Helpful Scripts , Jobs , SQL Administration , SQL Server

Since I seem to run across lots of questions about how to make sure that no jobs get in the way of ETL or other stressful data loads, I thought that I should post some ways you can stop jobs. https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-stop-job-transact-sql?view=sql-server-ver16 I have always done this by having a monitoring job that executes on a […]

Continue reading
Apr 11

Replication Slow at Subscriber Due to Missing Indexes

By Lori Brown | Helpful Scripts , Indexes , Replication , SQL Server

Problem Have you ever had transactional replication mysteriously start showing significant latency at a subscriber server?  If so, check to see if the primary keys from the publisher database are missing on the subscriber database! Replication was showing long latency while the publisher and subscriber servers were not heavily utilized.  Microsoft generated stored procedures that […]

Continue reading
Oct 12

Using Extended Events to Find Statement Causing a Job to Run Long or Hang

By Lori Brown | Extended Events , Helpful Scripts , Jobs , Performance Tuning , SQL Administration , SQL Server

On one of the servers that we monitor, it was reported that periodically a specific job would seem to hang and take forever to complete.  I was asked to set up something to help find exactly what statement in the job that was the root cause of the hang.  Since the issue only occurred intermittently, […]

Continue reading
1 2 3 22
>