SQL Server Performance

SQL Server 2005 Performance Tuning for DBAs

SQL Server 2005 DBA-related performance tuning questions.

Search this forum
Advanced search...
Page 3 of 27
Sort by:
Title Start Date
Replies Views ↓
Last Message
  1. DBADave

    How to determine when index statistics need updating?

    DBADave, Oct 8, 2008
    Replies:
    8
    Views:
    1,426
    reddy71752
    Dec 2, 2008
  2. ramyasundaram2002

    Unable to start a nested Transaction

    ramyasundaram2002, Apr 14, 2009
    Replies:
    3
    Views:
    1,418
    dhamu294
    Apr 14, 2009
  3. bleach77

    Need faster query for multiple left join

    bleach77, Jan 12, 2009
    Replies:
    9
    Views:
    1,403
    Luis Martin
    Sep 11, 2012
  4. sqlderby

    Performance Tuning - SP

    sqlderby, Jul 16, 2012
    Replies:
    2
    Views:
    1,353
    sqlderby
    Aug 16, 2012
  5. bagofbirds

    index fragmentation: how much is too much?

    bagofbirds, Jan 20, 2010
    Replies:
    5
    Views:
    1,316
    Luis Martin
    Jan 21, 2010
  6. Steph2004

    Slow clustered index seek

    Steph2004, Jan 22, 2008
    Replies:
    9
    Views:
    1,316
    ScottPletcher
    Jan 24, 2008
  7. hooifong

    SQL Server 2005 CPU bottleneck

    hooifong, Apr 14, 2011
    Replies:
    2
    Views:
    1,292
    amu_27
    Apr 29, 2011
  8. flaviotsf

    ISNULL vs OR IS NULL For Evaluting Parameter

    flaviotsf, Nov 23, 2006
    Replies:
    7
    Views:
    1,246
    ndinakar
    Dec 8, 2006
  9. IDTX2

    Use of UPPER in where clause while using case insensitive colation

    IDTX2, Oct 3, 2007
    Replies:
    4
    Views:
    1,164
    IDTX2
    Oct 3, 2007
  10. arobadol

    Do Index on table speed up query on View

    arobadol, May 24, 2006
    Replies:
    6
    Views:
    1,094
    samsoft
    Aug 25, 2009
  11. and.zanette

    How to reduce reserved size of a table

    and.zanette, Feb 18, 2008
    Replies:
    5
    Views:
    1,092
    satya
    Feb 19, 2008
  12. Balasundaram

    Performance Counter Values - Memory Pages/Sec

    Balasundaram, Apr 25, 2007
    Replies:
    8
    Views:
    1,089
    satya
    May 14, 2007
  13. mkal

    Max degree of parallelism question

    mkal, Sep 21, 2009
    Replies:
    9
    Views:
    1,074
    ghemant
    Oct 2, 2009
  14. jstevenson

    Create Index on a temp table

    jstevenson, Mar 7, 2010
    Replies:
    1
    Views:
    1,051
    Adriaan
    Mar 8, 2010
  15. choideyoung

    Stored Procedure to shrink log files

    choideyoung, Nov 9, 2006
    Replies:
    4
    Views:
    1,051
    mmarovic
    Nov 11, 2006
  16. eleung

    AWE and Virtual Memory Paging Files

    eleung, Apr 9, 2008
    Replies:
    8
    Views:
    1,031
    moh_hassan20
    Jul 12, 2009
  17. suvresh

    how to speed up freetext search

    suvresh, Jan 20, 2008
    Replies:
    5
    Views:
    1,009
    suvresh
    Jan 23, 2008
  18. wicket

    Reset statistics (Performance dashboard)

    wicket, May 13, 2007
    Replies:
    3
    Views:
    1,007
    satya
    May 14, 2007
  19. johnlv

    Index defrag seems to not work

    johnlv, Apr 24, 2006
    Replies:
    15
    Views:
    978
    Ola Hallengren
    Apr 24, 2008
  20. rhitti

    Error: 3023 - While Backup job is running on sql server 2005

    rhitti, Mar 17, 2009
    Replies:
    1
    Views:
    963
    techbabu303
    Mar 20, 2009
Showing threads 41 to 60 of 532

Thread Display Options

Loading...
Page 3 of 27