Andrew J. Kelly

Andrew J. Kelly is a contributing editor for SQL Server Pro, a SQL Server MVP, and the practice manager for performance and scalability at SolidQ. He has 20 years of experience with relational databases and application development. He is a regular speaker at conferences and user groups.Andrew J. Kelly is a contributing editor for SQL Server Pro, a SQL Server MVP and the practice manager for performance and scalability at SolidQ. He has 20 years of experience with relational databases and application development. He is a regular speaker at conferences and user groups.

Articles by Andrew J. Kelly
SQL Server Profiler or Server-Side Trace? 1
Did you know that using SQL Server Profiler can have an impact on the performance of your production servers? Check out these test results comparing SQL Server Profiler with a server-side trace.
Rebuild Only the Indexes that Need Help 9
Avoid re-indexing pandemonium by using the rebuild_indexes_by_db stored procedure to tackle only indexes that actually need help.
Who's Hogging My Server?
Obtain performance metrics by using SQL Server 2005’s built-in sys.dm_exec_plan_attributes DMV.
In Search of Duplicate Indexes on Your Tables 4
Heed this advice about how to identify duplicate or redundant indexes on the tables in your databases.
Dissecting SQL Server’s Top Waits
You know how to collect and report on wait stats. Now, let’s focus on a few wait stats that typically account for most overall system waits.
Are Your SQL Server Statements Performing Well? 7
SQL Server 2005 offers a relatively easy way to determine which SQL Server statements are causing you the most pain. A built-in DMV does the trick.
A SQL Server 2005 DMV Cleans Up Your Indexes 8
A SQL Server 2005 DMV eases the burden of cleaning up unused indexes. Get it working in your instance.
Boost Performance with Parallel Processing 2
Learn when and how to use SQL Server's parallel-processing settings, and you'll be able to achieve the best balance between concurrency and speed for your unique environment.
Getting to Know Wait Stats 4
SQL Server's built-in DMV functionality offers all kinds of management potential. This month, we show you how to monitor wait stats on your SQL Server instance.
Getting to Know Virtual File Stats 1
This built-in SQL Server 2005 DMV lets you see exactly what type of physical I/O your SQL Server system is experiencing when you're reading from or writing to the files on disk. Learn how to get the most out of it.
IT/Dev Connections

Register now to get the best rate available!

From the Blogs
computer keyboard with blue save money key
Apr 15, 2014
blog

Save Thousands in Licensing Costs for SQL Server AlwaysOn Availability Groups

Windows Server 2012 or Windows Server 2012 R2 Standard Edition is a great way to save thousands on licensing—and save yourself some serious headaches when deploying SQL Server AlwaysOn Availabiliity Groups....More
Apr 8, 2014
blog

NoSQL: Eventual Consistency Yields Major Flaws

While I believe that NoSQL can have some places where it legitimately makes sense, I also believe that NoSQL is also the patently wrong choice for a number of different types of applications or use cases....More
Apr 1, 2014
News

SQL Server 2014 Now Available—No Joke

Initial word on the street is that SQL Server 2014 has been very stable so far—which is probably why it went to release so quickly and bypassed what would typically have been another pre-release....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) ×