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

12 results found for Andrew J. Kelly, displaying items 1 - 12
November 2008  
Finding Your Top 10 SQL Server Queries
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.
SQL Server Magazine

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
Is Your Approach to VMware Server Recovery Outdated?
Is your data protected from server failure? Download this white paper to find the best way to back up, recover, and restore your VMware ESX Server 3.x.

Maximize speed, performance and reliablity of your PCs and servers—automatically!
Speed Up Your PC! Try Diskeeper 2008 with InvisiTasking Free Now!

GoGrid Offers FREE Trial for Windows Cloud Servers
Deploy Windows Server 2003 and 2008 with free load balancing through GoGrid’s award winning web-based GUI – all in less than 5 minutes

Order Your SQL Fundamentals CD Today!
Learn how to use SQL Server, understand Office integration techniques and dive into the essentials of SQL Express and Visual Basic with this free SQL Fundamentals CD.
You've Deployed SharePoint...Now What?
This one-day free online conference delivers the technical knowledge needed to kick MOSS up a notch. In one information-packed day, independent SharePoint experts will present practical, real-world information and provide take-away, ready-to-use solutions

Ease Your Scripting Pains with the Flexibility of PowerShell!
Paul Robichaux equips you with PowerShell basics in 3 introductory lessons, each followed by live Q&A—all on your own computer! Register today!

What Would You Do If You Ran Microsoft?
ITTV's 2008 inaugural video contest, "If I Ran Microsoft..." is your chance to tell it like it is. Be goofy or be serious, but don"t miss this chance to have fun, win prizes, and go viral in a major way.

Maximize Your SharePoint Investment
This web seminar discusses how true bi-directional replication of SharePoint content from one server to another enables branch offices to maintain access to current SharePoint content.

Rock Your Knowledge, and Compete with Friends and Colleagues!
Are you the Web Application Performance Guru in your office? It's time to have fun! Download now to access the crossword puzzle. Challenge yourself and complete this fun activity!
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