DBA Field Notes

This blog represents daily issues and solutions a DBA sees. The technology is focused on SQL Server and Mysql. These posts range from one line quick fixes to complex explanations of internal processes.

Thursday, September 14, 2017

Speeding up Min or Max ID’s on Partitioned Table

›

Speeding up Min or Max ID’s on Partitioned Table Overview A common scenario in using partitioned tables is to have a composite pri...

Wednesday, May 4, 2016

SQL Server Quickly Diagnosing Scans

›

Too often code gets released in production where the access path is a scan, as a DBA these are fairly easy to spot, without looking at a ...

Wednesday, April 27, 2016

Finding Blocking in Mysql

›

I’m primarily a SQL Server guy, but I’ve been lucky enough to have a handful of MYSQL databases to manage, and outside of our NDB cluster, ...

Tuesday, April 26, 2016

SQL Server Index index intersection with the "OR" clause

›

The two most hated things a DBA hates is a request for a backup from three years ago, and coming across a query with an OR clause in it...

›

Home

View web version

About Me

Ken Kaufman: I’m primarily focused on database performance and architecture within Internet operational shops. I’m currently the Lead DBA at Zillow.com managing multi-terabyte data stores. Including the blogs here I’ve contributed on sqlservercentral.com with both blog posts and articles in the past. In addition I was recently recognized as a finalist for the 2008 Exceptional DBA of the year http://www.exceptionaldba.com/vote.htm.

View my complete profile