Andrew J. Kelly

Andrew J.
Kelly

Andrew J. Kelly is a SQL Server MVP with over 20 years' experience with relational databases and application development but specializes in performance, scalability and maintainability of large scale SQL Servers. He is a regular speaker each year and a contributing editor and writer for SQL Server Pro.

Articles
Don’t Fear Dynamic SQL
When done correctly, dynamic SQL can be used effectively. Make sure you know how to get the most out of it.
Demystifying Minimal Logging 2
Stopping transaction logging completely isn’t possible, but you can drastically reduce what’s written to the transaction log with minimal logging. Here’s what you need to know, including the benefits minimal logging can reap.
Fine-Tuning Plan Reuse 4
Making sure that SQL Server’s procedure cache is as efficient as possible can save a considerable amount of time and resources.
top 10 phrase in blue and red
Top 10 SQL Server Performance Tuning Tips 10
It’s time for a system tune-up, and we have just the tools you need: A set of practical tips to help you optimize your SQL Server environment for peak performance.
Tackling SQL Server Query Basics
Weeding out the performance-killing statements in your SQL Server instance is certainly not beyond your capabilities and can take much less time and energy to solve than you realize.
The 4 Best Ways to Efficiently Address SQL Server Performance Problems 2
If you're trying to root out the causes of SQL Server performance problems, do you even know where to start? Wait statistics, file statistics, top 10 inefficient queries, and plan reuse are excellent first steps.
Is Tempdb Affecting Your Day-to-Day SQL Server Performance? 2
See if these tips can make a difference in your overall performance of SQL Server activity.
hourglass with blue sand on a computer keyboard
Is Your Physical Disk I/O Affecting SQL Server Performance? 1
Get a handle on the fundamentals of acceptable physical I/O for SQL Server and learn how to determine whether it's affecting your system's performance.
Do You Have Hidden Cache Problems? 5
Most people know that proper plan reuse is essential to good performance but there is another aspect that everyone should explore to ensure peak performance.
Time to Defrag Your Indexes?
When is the right time to defrag? Ultimately, the answer is up to you, but keep these considerations in mind.
Diving Deeper into Wait Stats
In two previous articles, I've discussed SQL Server 2005 waits and showed you some of the more common ones. Now, let's dive down for a deeper view of what each connection or even thread in the SQL Server instance is waiting on.
Focus on Files and Filegroups 1
Most SQL Server DBAs wonder how many data files or filegroups they should have when they create a new user database. But they should be focusing on how to better utilize filegroups rather than on how many files they need.
Trace Reporting with RML Utilities
Are you using SQL Server's CLR functionality to parse trace files? Microsoft recently updated its RML Utilities, and you might find them easier to use—and a great benefit to your arsenal.
Finding Your Top 10 SQL Server Queries 3
Need to parse server-side trace information so that you can aggregate the data to find your worst-performing and most-called queries? The user-defined SQL_Signature function should do the trick.
Generating Server-Side Traces
In creating a server-side trace, your goal is to capture the events you're interested in and store them in on a locally attached disk on the server. Use these T-SQL commands to accomplish that goal.
Upcoming Conferences

Register now to get the best rate available!

From the Blogs
Baby duck swimming alone
Jul 15, 2014
blog

The Marginalization of SQL Server Standard Edition 5

Microsoft seems to be bent on marginalizing SQL Server Standard Edition—both in the sense of the artificial constraints placed upon how much memory it can use, and in terms of what seems to be a shift in focus on the role of Standard Edition from Microsoft....More
Jul 8, 2014
blog

Replication: Sometimes More is Less

The unconventionality of having two publications for complex, unruly databases typically ends up saving huge amounts of time over the long haul and makes replication much easier to manage....More
Red restore key on computer keyboard
Jun 24, 2014
blog

AlwaysOn Availability Groups and Third Party Log Readers

When DBAs and SysAdmins learn the ins-and-outs of AlwaysOn Availability Groups, they’re then able to address high availability and disaster recovery concerns from a single interface or set of tooling, thus providing better scalability of management....More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.

Sponsored Introduction Continue on to (or wait seconds) ×