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/

Technical Article

sp_PerfSQ

A diagnostic tool for identifying Performance features of active SQL Queries. It collects performance detail from DMVs for queries with executing requests and is designed to demonstrate and quantify Query Shaping optimisation techniques by: quantifying query workload and throughput characteristics providing behavioural descriptors of potential performance inhibitors - refer column ThrottlePotential The ThrottlePotential column is […]

(3)

You rated this post out of 5. Change rating

2019-11-07

4,155 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

SQl Server 2014 linked server remote server

By johnnyrmtl

Hello all, I have a linked server created on an instance which only has...

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

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