SQL Server Performance

Search Results

Search Again
  1. Trond

    Tuning advice - long duration values from profiler

    Post by: Trond, Feb 4, 2009 in forum: SQL Server 2005 T-SQL Performance Tuning
    Thanks for your help Elisabeth. Running the statements in SSMS gives much shorter duration. We have earlier changed the CursorTypeEnum in Access...
  2. Trond

    Tuning advice - long duration values from profiler

    Thread by: Trond, Feb 3, 2009, 3 replies, in forum: SQL Server 2005 T-SQL Performance Tuning
    <p>&nbsp;<img src="http://www.elinogtrond.com/wp-content/uploads/result.png" title="Profiler result" alt="Profiler result"...
  3. Trond

    Reindex

    Post by: Trond, Aug 24, 2007 in forum: Performance Tuning for DBAs
    The table got 15848 rows.
  4. Trond

    Reindex

    Thread by: Trond, Aug 23, 2007, 5 replies, in forum: Performance Tuning for DBAs
    I’m tryingto rebuild some fragmented indexes. The “dbcc showcontig” gave this result: Table:'ArtikkelDetaljer' (324196205); index ID: 5,...
  5. Trond

    Performace-trouble with MSDE

    Post by: Trond, Aug 16, 2007 in forum: Performance Tuning for DBAs
    We are evaluating a migration to SQL Express 2005. But I don’t understand this: A couple of hours ago Istarted logging concurrency-violations....
  6. Trond

    Performace-trouble with MSDE

    Thread by: Trond, Aug 16, 2007, 3 replies, in forum: Performance Tuning for DBAs
    We havea system using MS Access working against a db on MSDE 2000. This architectureand system has been in use for a long time. But lately (the last...
Showing results 1 to 6 of 6
Search Again