SQL Server Performance

Search Results

Search Again
  1. ZLA

    SQL Server 2000 - Reorganize same as Rebuild?

    Thread by: ZLA, Jun 23, 2008, 2 replies, in forum: Performance Tuning for DBAs
    Under SQL Server 2000 Enterprise Manager's Database Maintenance Plan, is the option to "Reorganize data and index pages" the same as executing the...
  2. ZLA

    How bad are clustered indexes using a varchar column?

    Thread by: ZLA, Jun 19, 2008, 2 replies, in forum: T-SQL Performance Tuning for Developers
    In general, I've seen a comment that varchar columns don't make efficient index columns. However, I have a customer material table which has two main...
  3. ZLA

    Index Tuning Wizard and First Statement in a Batch Limitation

    Thread by: ZLA, Jun 19, 2008, 5 replies, in forum: Performance Tuning for DBAs
    According to SQL Server Query Performance Tuning Distilled by Sajal Dam, the Index Tuning Wizard only looks at the first SQL statement in a batch...
  4. ZLA

    How to test Index Tuning Changes before implementing in Production?

    Thread by: ZLA, Jun 19, 2008, 2 replies, in forum: T-SQL Performance Tuning for Developers
    I am working with SQL Profiler and the Index Tuning Wizard in order to improve the database performance for my client's web site. Before I implement...
  5. ZLA

    How to test Index Tuning Changes before implementing in Production?

    Thread by: ZLA, Jun 19, 2008, 1 replies, in forum: SQL Server 2005 T-SQL Performance Tuning
    I am working with SQL Profiler and the Index Tuning Wizard in order to improve the database performance for my client's web site. Before I implement...
  6. ZLA

    Database design for combination OLTP / Reporting database

    Thread by: ZLA, Jun 14, 2008, 3 replies, in forum: T-SQL Performance Tuning for Developers
    I have a B2B web site that supports both online transactional processing as well as reporting requests. This is not what one would consider a high...
Showing results 1 to 6 of 6
Search Again