April 2006

  • Part 3: Associating SQL Profiler and Performance Monitor data

    Learn how to map micro-level data to macro-level metrics by associating SQL Profiler and Performance Monitor. This section helps you associate and analyze data from each tool.27 Apr 2006

  • Part 2: Capturing data in SQL Profiler and Performance Monitor

    Learn how to map micro-level data to macro-level metrics by associating SQL Profiler and Performance Monitor. This section helps you capture data in each tool.27 Apr 2006

  • SQL Server 2005 guide to performance metrics

    SQL Server 2005 allows you to map micro-level data to macro-level metrics by associating SQL Profiler and Performance Monitor in one interface. Edgewood Solutions' Jeremy Kadlec explains how to do ...27 Apr 2006

  • Part 1: Configuring Profiler and Performance Monitor

    Learn how to map micro-level data to macro-level metrics by associating SQL Profiler and Performance Monitor. This step helps you configure each tool.27 Apr 2006

  • VB.NET timing out when backup changed to hourly

    After changing transaction log backups from daily to hourly, one ITKnowledge Exchange member noticed that VB.NET was timing out. Find out what advice his peers have to offer.26 Apr 2006

  • When not to use indexes

    One of the most important questions is when should you create an index. This book excerpt will help you find the answer.25 Apr 2006

  • Building fast-performing database models

    This chapter from the book Beginning Database Design describes various factors affecting database performance tuning, as applied to different database model types.25 Apr 2006

  • The HAVING and WHERE clauses

    A common programming error is to confuse the purpose of WHERE and HAVING clause filters. Don't make that mistake. Read about the differences in this book excerpt.25 Apr 2006

  • Auto counters

    Learn about the purpose of auto counters in relational databases in this book excerpt.25 Apr 2006

  • Joins

    Learn about different join types and their tuning attributes in this book excerpt.25 Apr 2006

  • How to apply indexes in the real world

    The way an index is applied is generally dependent on the function of the table for which the index is created. Learn how to apply indexes in this book excerpt.25 Apr 2006

  • The SELECT command

    There are a number of points to remember when building efficient queries. Read about them in this book excerpt.25 Apr 2006

  • Using views

    Understand how and why views are used by administrators -- and when is the right time to use them -- in this book excerpt.25 Apr 2006

  • The needs of different database models

    Understand the performance survival needs of different database model types -- OLTP, client server and data warehouse -- in this book excerpt.25 Apr 2006

  • Writing efficient queries

    Database model tuning comes with one big stipulation. Find out what it is in this book excerpt.25 Apr 2006

  • Database modeling exercises

    Test what you've learned in this 'Building Fast-Performing Data Models' chapter with this collection of exercises.25 Apr 2006

  • Understanding database model tuning

    Database model tuning comes with one big stipulation. Find out what it is in this book excerpt.25 Apr 2006

  • Application caching

    Caching may provide you with an effective way to perfomance tune your database. Read about caching in this book excerpt.25 Apr 2006

  • Filtering with the WHERE clause

    There are many points to keep in mind when building efficient filtering for faster execution of SQL code. Read about them in this book excerpt.25 Apr 2006

  • Working with schemas in SQL Server 2005

    If you're managing too many databases with too many objects, it may be time to take advantage of SQL Server 2005's ANSI SQL feature: schemas.25 Apr 2006