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,721 reads

Blogs

T-SQL Tuesday Retrospective #015: Automation

By

In February 2011, Pat Wright invited us to talk about Automation: So the topic...

Daily Coping 12 May 2021

By

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

Updated Pluralsight Course – Managing the Kubernetes API Server and Pods

By

My updated course “Managing the Kubernetes API Server and Pods” in now available on Pluralsight here! If...

Read the latest Blogs

Forums

SQL 2012 Standard - Index highly fragmented

By mjbc

Hi there, Complete newb.  Need some guidance. Running SQL 2012, running INFOR ERP.  Indexes...

Manual tasks in SSIS design

By Roust_m

Hi, I am getting CSV files with hundreds of columns many of which have...

Loading a csv file into sql server table

By Roust_m

Hi, I've created a simple dataflow with flat file source and sql server destination....

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers