http://www.sqlmag.com/authors/author/author/3947067/rss/3947067en-USFri, 25 May 2012 10:20:46 GMTFri, 25 May 2012 10:20:46 GMThttp://www.sqlmag.com/article/performancetuning/dont-fear-dynamic-sql-140265
By Andrew Kelly
When done correctly, dynamic SQL can be used effectively. Make sure you know how to get the most out of it. ]]>Andrew KellyTue, 18 Oct 2011 10:06:00 GMThttp://www.sqlmag.com/article/performancetuning/dont-fear-dynamic-sql-140265http://www.sqlmag.com/article/performance-tuning/demystify-minimal-logging-129916
By Andrew J. Kelly
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.]]>Andrew J. KellyFri, 20 May 2011 14:35:00 GMThttp://www.sqlmag.com/article/performance-tuning/demystify-minimal-logging-129916http://www.sqlmag.com/article/sql-server/fine-tuning-plan-reuse-129462
By Andrew J. Kelly
Making sure that SQL Server’s procedure cache is as efficient as possible can save a considerable amount of time and resources.]]>Andrew J. KellyWed, 16 Mar 2011 07:02:00 GMThttp://www.sqlmag.com/article/sql-server/fine-tuning-plan-reuse-129462http://www.sqlmag.com/article/project-plan-dbadmin-sql-server-2008-r2-79/sql-server/top-10-performance-tips-for-sql-server
By Andrew J. Kelly
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.]]>Andrew J. KellyWed, 08 Dec 2010 15:03:00 GMThttp://www.sqlmag.com/article/project-plan-dbadmin-sql-server-2008-r2-79/sql-server/top-10-performance-tips-for-sql-serverhttp://www.sqlmag.com/article/sql-server/tackling-the-sql-server-performance-basics
By Andrew J. Kelly
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.]]>Andrew J. KellyMon, 25 Oct 2010 16:30:00 GMThttp://www.sqlmag.com/article/sql-server/tackling-the-sql-server-performance-basicshttp://www.sqlmag.com/article/sql-server/the-4-best-ways-to-efficiently-address-sql-server-performance-problems
By Andrew J. Kelly
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.]]>Andrew J. KellyTue, 24 Aug 2010 09:56:00 GMThttp://www.sqlmag.com/article/sql-server/the-4-best-ways-to-efficiently-address-sql-server-performance-problemshttp://www.sqlmag.com/article/sql-server/is-tempdb-affecting-your-day-to-day-sql-server-performance-
By Andrew J. Kelly
See if these tips can make a difference in your overall performance of SQL Server activity.]]>Andrew J. KellyWed, 23 Jun 2010 16:57:00 GMThttp://www.sqlmag.com/article/sql-server/is-tempdb-affecting-your-day-to-day-sql-server-performance-http://www.sqlmag.com/article/business-intelligence/is-your-physical-disk-i-o-affecting-sql-server-performance-
By Andrew J. Kelly
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.]]>Andrew J. KellyMon, 26 Apr 2010 15:51:00 GMThttp://www.sqlmag.com/article/business-intelligence/is-your-physical-disk-i-o-affecting-sql-server-performance-http://www.sqlmag.com/article/performance/do-you-have-hidden-cache-problems-
By Andrew J. Kelly
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.]]>Andrew J. KellyTue, 23 Feb 2010 00:00:00 GMThttp://www.sqlmag.com/article/performance/do-you-have-hidden-cache-problems-http://www.sqlmag.com/article/performance/time-to-defrag-your-indexes-
By Andrew J. Kelly
When is the right time to defrag? Ultimately, the answer is up to you, but keep these considerations in mind.]]>Andrew J. KellyMon, 28 Sep 2009 00:00:00 GMThttp://www.sqlmag.com/article/performance/time-to-defrag-your-indexes-http://www.sqlmag.com/article/performance/diving-deeper-into-wait-stats
By Andrew J. Kelly
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.]]>Andrew J. KellySat, 13 Jun 2009 00:00:00 GMThttp://www.sqlmag.com/article/performance/diving-deeper-into-wait-statshttp://www.sqlmag.com/article/performance/focus-on-files-and-filegroups
By Andrew J. Kelly
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.]]>Andrew J. KellyThu, 16 Apr 2009 00:00:00 GMThttp://www.sqlmag.com/article/performance/focus-on-files-and-filegroupshttp://www.sqlmag.com/article/sql-server/trace-reporting-with-rml-utilities
By Andrew J. Kelly
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.]]>Andrew J. KellyWed, 11 Feb 2009 00:00:00 GMThttp://www.sqlmag.com/article/sql-server/trace-reporting-with-rml-utilitieshttp://www.sqlmag.com/article/performance/finding-your-top-10-sql-server-queries
By Andrew J. Kelly
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.]]>Andrew J. KellyThu, 30 Oct 2008 00:00:00 GMThttp://www.sqlmag.com/article/performance/finding-your-top-10-sql-server-querieshttp://www.sqlmag.com/article/performance/generating-server-side-traces
By Andrew J. Kelly
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.]]>Andrew J. KellyMon, 29 Sep 2008 00:00:00 GMThttp://www.sqlmag.com/article/performance/generating-server-side-traceshttp://www.sqlmag.com/article/performance/sql-server-profiler-or-server-side-trace-
By Andrew J. Kelly
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.]]>Andrew J. KellyWed, 30 Jul 2008 00:00:00 GMThttp://www.sqlmag.com/article/performance/sql-server-profiler-or-server-side-trace-http://www.sqlmag.com/article/performance/rebuild-only-the-indexes-that-need-help
By Andrew J. Kelly
Avoid re-indexing pandemonium by using the rebuild_indexes_by_db stored procedure to tackle only indexes that actually need help.]]>Andrew J. KellyFri, 27 Jun 2008 00:00:00 GMThttp://www.sqlmag.com/article/performance/rebuild-only-the-indexes-that-need-helphttp://www.sqlmag.com/article/sql-server-2005/in-search-of-duplicate-indexes-on-your-tables
By Andrew J. Kelly
Heed this advice about how to identify duplicate or redundant indexes on the tables in your databases. ]]>Andrew J. KellyTue, 29 Apr 2008 00:00:00 GMThttp://www.sqlmag.com/article/sql-server-2005/in-search-of-duplicate-indexes-on-your-tableshttp://www.sqlmag.com/article/performance/dissecting-sql-server-s-top-waits
By Andrew J. Kelly
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.]]>Andrew J. KellyFri, 28 Mar 2008 00:00:00 GMThttp://www.sqlmag.com/article/performance/dissecting-sql-server-s-top-waitshttp://www.sqlmag.com/article/performance/are-your-sql-server-statements-performing-well-
By Andrew J. Kelly
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.]]>Andrew J. KellyThu, 28 Feb 2008 00:00:00 GMThttp://www.sqlmag.com/article/performance/are-your-sql-server-statements-performing-well-