Forum Replies Created

Viewing 15 posts - 38,131 through 38,145 (of 49,552 total)

  • RE: optimizig the queries in need some links

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

    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

    June 27, 2009 at 4:01 am

    #1016385

  • RE: Why do I have to register again to see articles?

    Barry, I think he's talking about the "Additional Articles" that appear on the home page that are from TechNet, SearchSQLServer or other sites.

    vgrimes: If you look at the notes beneath...

    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

    June 27, 2009 at 3:48 am

    #1016382

  • RE: "1/1/1900 12:00:00 AM" Date Problem

    Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic743086-149-1.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

    June 27, 2009 at 3:43 am

    #1016381

  • RE: "1/1/1900 12:00:00 AM" Date Problem in SQL Server 2005

    1/1/1900 is 0 as a date. It means that either you're explicitly inserting the value 0 or '' into that column, or there's a default of 0 or '' on...

    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

    June 27, 2009 at 3:43 am

    #1016380

  • RE: Indexes with Include

    Grant Fritchey (6/26/2009)

    I wanted to be sure of the answer before I posted it, but it seems that SQL Server will most frequently pick the index with the most columns....

    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

    June 26, 2009 at 1:46 pm

    #1016264

  • RE: Indexes with Include

    Ray Laubert (6/26/2009)

    The question then becomes does SQL treat the selection of covering indexes the same way it does the selection of candidate indexes. left to right and stopping...

    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

    June 26, 2009 at 12:12 pm

    #1016224

  • RE: Tail backup/restore question

    Daniel C (6/26/2009)

    How can I get those last transactions from the active log?

    Do a last log backup and select the option "Back up the tail log, and leave the database...

    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

    June 26, 2009 at 12:11 pm

    #1016223

  • RE: 911 - Cursor killing my trigger

    Scott Coleman (6/26/2009)

    So you're saying you have to count all the notes for an incident, and the sequence number of the one you're looking for is in the Custom_1 field?...

    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

    June 26, 2009 at 12:00 pm

    #1016221

  • RE: Are the posted questions getting worse?

    Grant Fritchey (6/26/2009)

    And if things get REALLY bad, we'll just toss Gail into the middle of them. Although, that might be considered a cruel thing to do to a crowd......

    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

    June 26, 2009 at 9:27 am

    #1016121

  • RE: 911 - Cursor killing my trigger

    rkwitcher (6/26/2009)

    Thanks Gail, but I must get a recordset and choose the the correct record to get the NoteID.

    -I have a list of notes on and incident.

    -Someone selects...

    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

    June 26, 2009 at 9:22 am

    #1016115

  • RE: choosing best index columns

    shnex (6/26/2009)

    Unfortunately the pk is a uniqueidentifier...but I asked you before about this and we agree that is better to put on the uniqueidentifier than not to put one at...

    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

    June 26, 2009 at 9:20 am

    #1016113

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (6/26/2009)

    Alright, I'm leaving for a week. Behave yourselves on the thread.

    Where you off to?

    Tony watching the place while you're gone?

    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

    June 26, 2009 at 9:06 am

    #1016096

  • RE: 911 - Cursor killing my trigger

    Couple problems straight off.

    That trigger will only work right if there's one row updated. If there's more than one row updated, only one of them is going to be 'processed'

    You're...

    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

    June 26, 2009 at 9:01 am

    #1016089

  • RE: choosing best index columns

    shnex (6/26/2009)

    I have a index seek only for id and fk3(the first column in the enumeration for non cl index). The result was the same for other examples too, 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

    June 26, 2009 at 8:52 am

    #1016083

  • RE: printing 1 to 100 in SQL Server as a batch....

    Ian Scarlett (6/26/2009)

    I think you need to test the solutions in your blog first.

    The "Procedure for droping all constraints from a table" won't work because of this (amongst other things):-

    WHILE(@@FETCH_STATUS-1)

    Also...

    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

    June 26, 2009 at 8:07 am

    #1016046

Viewing 15 posts - 38,131 through 38,145 (of 49,552 total)