Windows IT Pro is the authoritative and independent resource for windows nt, windows 2000, windows 2003, windows xp. Features a collection of resources and magazines for windows IT professionals.
  
  
  Advanced Search 


 
Andrew J. Kelly
   

Andrew J. Kelly is a SQL Server MVP and the practice manager for performance and scalability at Solid Quality Mentors. He has 20 years experience with relational databases and application development. He is a regular speaker at conferences and user groups.
Email address: AKelly@SolidQ.com

11 results found for Andrew J. Kelly, displaying items 1 - 11
October 2008  
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.
SQL Server Magazine

August 2008  
SQL Server Profiler or Server-Side Trace?
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.
SQL Server Magazine

July 2008  
Rebuild Only the Indexes that Need Help
Avoid re-indexing pandemonium by using the rebuild_indexes_by_db stored procedure to tackle only indexes that actually need help.
SQL Server Magazine

April 29, 2008  
In Search of Duplicate Indexes on Your Tables
Windows IT Pro

May 2008  
In Search of Duplicate Indexes on Your Tables
Heed this advice about how to identify duplicate or redundant indexes on the tables in your databases.
SQL Server Magazine

April 2008  
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.
SQL Server Magazine

March 2008  
Are Your SQL Server Statements Performing Well?
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.
SQL Server Magazine

January 2008  
A SQL Server 2005 DMV Cleans Up Your Indexes
A SQL Server 2005 DMV eases the burden of cleaning up unused indexes. Get it working in your instance.
SQL Server Magazine

December 18, 2007  
A SQL Server 2005 DMV Cleans Up Your Indexes
Windows IT Pro

November 2007  
Boost Performance with Parallel Processing
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.
SQL Server Magazine

October 2007  
Getting to Know Wait Stats
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.
SQL Server Magazine





ADS BY GOOGLE SPONSORED LINKS FEATURED LINKS

Microsoft Exchange & Windows Connections event returns to Las Vegas Nov 10 - 13
Connections returns to Las Vegas for this exciting event where each attendee will receive SQL Server 2008 standard with 1 CAL. Co-located with Microsoft ASP.NET, SQL Server, and SharePoint Connections with over 250 in-depth sessions.

Free Online Event! Virtualization:Get the Facts!
Register now and attend this free, live in-depth online conference on November 13 and 20, 2008, produced by Windows IT Pro. All registrants are eligible to receive a complimentary one-year digital subscription to Windows IT Pro (a $49.95 value)!

Check Out Hyper-V Video on ITTV
Watch Karen Forster's interview on Hyper-V's performance on ITTV.net.

Ease Your Scripting Pains with the Flexibility of PowerShell!
Join MVP Paul Robichaux on December 11, 2008 at 11:00 AM EDT as he equips you with PowerShell basics in 3 introductory lessons, each followed by a live Q&A session—all on your own computer!

PASS Community Summit 2008 in Seattle on Nov 18-21
The don’t-miss event for Microsoft SQL Server Professionals. Register now and you’ll enjoy top-notch Microsoft and Community speakers and more.



Speed Up Your PC!
Try Diskeeper 2008 with InvisiTasking Free Now!

Get Protected -- Data Protection Manager 2007
Protect your virtualized environment with Data Protection Manager

Agent-less Remote Backup Service, Free 30 Day Trial
Award winning remote backup service at a competitive price with no min GB/month. Sign up Now!

ScriptLogic Cartoon Caption Contest
Submit your caption and you will be entered to win $198.42

List Your Products in Our Technology Resource Directory
Don't miss the chance to post your free listing in this comprehensive directory for IT and developer professionals, powered by Windows IT Pro. But hurry! Deadline ends Oct. 9.
Windows IT Pro Home Register FAQ for Windows WinInfo News
Europe Edition About Us Contact Us/Customer Service Media Kit Affiliates / Licensing  
SQL Server Magazine Office & SharePoint Pro Windows Dev Pro IT Job Hound ITTV
IT Library Technology Resource Directory Connected Home Windows Excavator Windows SuperSite 
 
 Windows IT Pro is a Division of Penton Media Inc.
 Copyright © 2008 Penton Media, Inc., All rights reserved. Terms and Use | Privacy Statement | Reprints and Licensing