Forum Replies Created

Viewing 15 posts - 30,661 through 30,675 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    WayneS (9/16/2010)

    But Gail, you know that there are so many other people that truly appreciate you. Just ignore the ID 10 T's and help those that appreciate it.

    Yeah. Still hurts...

    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

    September 16, 2010 at 1:57 am

    #1221968

  • RE: Index Defragmentation

    Sorry, don't understand what you're asking.

    Do you know why fragmentation affects performance?

    Also, think of the relative sizes of the leaf and non-leaf levels of an index, and the suggested...

    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

    September 16, 2010 at 1:36 am

    #1221962

  • RE: simple SELECT query takes ten seconds to return 5000 rows - can I optimize?

    Can you post the full execution plan as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/?

    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

    September 16, 2010 at 1:28 am

    #1221955

  • RE: Index on BIT column

    An index just on that column will probably not be useful. What you'll likely need to do is create indexes for the various queries and ensure that the IsDeleted is...

    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

    September 16, 2010 at 1:27 am

    #1221953

  • RE: Index Defragmentation

    Bhuvnesh (9/15/2010)

    GilaMonster (9/13/2010)

    Defrag only works on the leaf level of the index (level 0) .

    Then what about the intermediate level ?

    Defrag (Alter index Reorganise) does not touch anything other than...

    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

    September 16, 2010 at 1:19 am

    #1221949

  • RE: D: drive is full and transaction log is full

    Ok, before going on I'd really like an answer to what I asked last night.

    What is that actual state of the database? (query sys.databases)?

    Also please check the error log and...

    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

    September 16, 2010 at 1:17 am

    #1221948

  • RE: MCTS content

    Ali Tailor (9/15/2010)

    U can refer any testing software also, for time managing and better result. I refer transcender for mine exam.

    Off hand, no idea. Sorry. I haven't used Transcender since...

    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

    September 16, 2010 at 1:16 am

    #1221947

  • RE: Critical issues detected by SQL Server BPA

    Mark Enloe (9/15/2010)

    And Gail, thanks for confirming what I suspected. And I'm not sure about the 2 year old post comment. Do you mean that you're not as...

    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

    September 16, 2010 at 1:11 am

    #1221942

  • RE: Are the posted questions getting worse?

    Combine this and the BIT thread and I'm just about ready to throw in the towel.

    http://www.sqlservercentral.com/Forums/FindPost986824.aspx

    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

    September 16, 2010 at 1:10 am

    #1221939

  • RE: D: drive is full and transaction log is full

    Craig Farrell (9/15/2010)

    Can't argue that, but anytime I hear they filled the drive with their log, I usually assume the entire thing was active, and rolling back that monster they...

    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

    September 15, 2010 at 4:47 pm

    #1221782

  • RE: D: drive is full and transaction log is full

    Craig Farrell (9/15/2010)

    If you're stuck in recovery mode, it sounds like someone cycled the server. On a log THAT big, it can take a while. Around how long...

    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

    September 15, 2010 at 4:16 pm

    #1221764

  • RE: D: drive is full and transaction log is full

    What's the state of the database? (state_desc in sys.databases)

    If RECOVERING, wait. It should finish eventually.

    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

    September 15, 2010 at 4:14 pm

    #1221762

  • RE: Critical issues detected by SQL Server BPA

    Mark Enloe (9/15/2010)

    Some others on the site appear to be more interested in providing condescending, pompous replies that do nothing to help and only show that the poster doesn't really...

    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

    September 15, 2010 at 4:07 pm

    #1221760

  • RE: ORDER BY not working

    I'm guessing you didn't test that, as neither the create table nor the inserts worked.

    I fixed it for you this time:

    CREATE TABLE [dbo].[pageList] (

    ...

    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

    September 15, 2010 at 10:03 am

    #1221487

  • RE: ORDER BY not working

    Table definition and query please.

    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

    September 15, 2010 at 9:18 am

    #1221429

Viewing 15 posts - 30,661 through 30,675 (of 49,552 total)