Forum Replies Created

Viewing 15 posts - 45,226 through 45,240 (of 49,552 total)

  • RE: Which index option is the best

    usman.tanveer (8/8/2008)

    Actually there are multiple queries and most of the times they are dynamic.

    But what is the best practice or general practice for creating indexes?seperate index on each column...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 8, 2008 at 7:43 am

    #855173

  • RE: The Active DBA

    majorbloodnock (8/8/2008)

    GilaMonster (8/8/2008)

    Someguy (8/8/2008)

    I'm surprised how many of the readers here are into martial arts.

    There's an interesting correlation between IT (and the wider science field) and martial arts. When...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 8, 2008 at 7:41 am

    #855171

  • RE: Temp DB FULL

    Kumar (8/8/2008)

    You could shrink the file or bounce the SQL Instance... 🙂

    If the file is full (no free space within) then shrinking the file (releasing free space within the file...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 8, 2008 at 7:38 am

    #855170

  • RE: SQL 2000 EE on Windows 2003 16GB -- > AWE??

    If you are using more than 4 GB on a 32 bit system, you need AWE. Otherwise the max that a process can use is 2GB (or 3GB with /3GB)

    Do...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 8, 2008 at 7:37 am

    #855168

  • RE: INNER JOIN Best Practice & Optimisation

    Muhammad Tariq (8/8/2008)

    can you try using table level lock hint? e.g. with (nolock), i found some times non-ignorable outcomes by using this hint.

    Ow. Table and locking hints should be the...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 8, 2008 at 7:13 am

    #855132

  • RE: Automatic Statistics Maintenance - Good or Bad

    Christopher Stobbs (8/8/2008)

    Also is this just simply a matter of manually droping and recreating the indexes?

    ALTER INDEX ... REBUILD

    Don't do it while the systems are in use. It's a maintenance...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 8, 2008 at 6:58 am

    #855113

  • RE: Which index option is the best

    Very hard to say without seeing the queries and maybe the table definition.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 8, 2008 at 6:54 am

    #855108

  • RE: INNER JOIN Best Practice & Optimisation

    The order which you specify the tables has no effect. The optimiser will join the tables in the order it considers most optimal.

    Can you post the definition of the tables,...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 8, 2008 at 6:54 am

    #855105

  • RE: The Active DBA

    Someguy (8/8/2008)

    I'm surprised how many of the readers here are into martial arts.

    There's an interesting correlation between IT (and the wider science field) and martial arts. When I was...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 8, 2008 at 6:45 am

    #855096

  • RE: Automatic Statistics Maintenance - Good or Bad

    Auto create stats on, auto update stats on. If you find stats that aren't getting updated often enough, or find ones where the sampling is too low, create a job...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 8, 2008 at 6:44 am

    #855095

  • RE: Pls help me out with the queries

    Is this for a test, homework, an interview or similar?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 8, 2008 at 1:59 am

    #854962

  • RE: PAGEIOLATCH_SH and memory

    PageIOLatches often indicate slow disks. Try the following counters

    Physical Disk avg sec/read

    Physical Disk avg sec/write

    Physical Disk % idle time

    SQL Buffer manager checkpoint pages/sec

    SQL Buffer manager lazy writes/sec

    Pages/sec just gets you...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 8, 2008 at 1:56 am

    #854960

  • RE: The Active DBA

    Aikido 2-3 nights a week and archery every second weekend. I also do a little weightlifting and other gymnastic-style workouts from time to time, purely for fitness.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 8, 2008 at 1:52 am

    #854959

  • RE: Backup-failing with I/O error

    Please note that the post you are answering is almost a year old.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 8, 2008 at 1:42 am

    #854955

  • RE: Beat this - comic relief for the day

    jcrawf02 (8/6/2008)

    Had to throw this one in for good measure. I know you all love to hate on developers, and here's a good lesson in why you shouldn't comment things...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 8, 2008 at 1:31 am

    #854951

Viewing 15 posts - 45,226 through 45,240 (of 49,552 total)