SQL Server Performance

Search Results

Search Again
  1. evgeny

    Table using too much space before shrinking

    Post by: evgeny, Jan 29, 2008 in forum: Performance Tuning for DBAs
    I don't think it was all just bad statistics, though. Initially, the reported usage was over 2000 MB and the actual DB file and backups were much...
  2. evgeny

    Table using too much space before shrinking

    Post by: evgeny, Jan 28, 2008 in forum: Performance Tuning for DBAs
    Thanks for the replies. Yes, turns out there is a clustered index. It's on a GUID column, so should I replace it with a non-clustered one? Here's...
  3. evgeny

    Table using too much space before shrinking

    Thread by: evgeny, Jan 24, 2008, 7 replies, in forum: Performance Tuning for DBAs
    Hi, I have a SQL 2000 table that stores two UNIQUEIDENTIFIERs and 1 SMALLINT. New rows are frequently inserted into this table and over time the...
Showing results 1 to 3 of 3
Search Again