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/

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 […]

5 (3)

2019-11-07

2,508 reads

Blogs

It’s 2021, so why are you reading this?

By

If you’re reading this, there’s a good chance you’re straight, white, male, and English-speaking....

Daily Coping 20 Jan 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

[Coping] Hidden Wounds

By

Through high school and college, I carried deep wounds due to what was going...

Read the latest Blogs

Forums

Find unmatched between 2 tables using field as selection criteria

By McGoo2000

I have the following tables as a example. Table 1 EmpID, LastName, FirstName 1,Smith,John...

update using self-join - confirm it looks at old values

By ztoddw

I'm doing an update using a self-join, and just want to confirm something.  If...

Representative Data Challenges

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Representative Data Challenges

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers