Edward Haynes

Over 20 years experience in SQL Server development & administration, and creator of "Query Shaping" an innovative SQL query optimisation technique.
Find me on LinkedIn:
https://www.linkedin.com/in/edward-haynes-sql/

SQLServerCentral Article

Query Performance Diagnostics with sp_PerfSQ

This article discusses sp_PerfSQ a diagnostic tool designed to quantify performance features of database queries with active requests. It includes a behavioural parser and can assist in troubleshooting complex performance issues.

(10)

You rated this post out of 5. Change rating

2021-12-24 (first published: )

11,498 reads

Blogs

Getting SQL Server 2025 RTM Running in Containers on macOS

By

SQL Server 2025 RTM is here, and if you’re running Docker on macOS, you...

The PASS Data Community Summit 2025 Recap

By

It’s Monday. I’ve been home since Fri night, but with a busy weekend, I’m...

Microsoft Post-Quantum Crypto APIs Are Now Generally Available

By

I mentioned this in my talk on Quantum Computing at the PASS Data Community...

Read the latest Blogs

Forums

Find all the tables in a database containing particular column value

By RCRock

Hi, I want to find all the tables name under a database where tables...

The Ending Substring

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Ending Substring

Done is Better than Good

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Done is Better than Good,...

Visit the forum

Question of the Day

The Ending Substring

In Azure SQL Database and SQL Server 2025, if I run this, what is returned?

SELECT '[' + SUBSTRING('Steve Jones', 7) + ']'

See possible answers