Forum Replies Created

Viewing 15 posts - 28,981 through 28,995 (of 49,552 total)

  • RE: Today's Random Word!

    Tom.Thomson (12/7/2010)

    Not at all, unless within sight (if I can see you and I ask your age that's rude, because I am required to believe that you are the youngest...

    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

    December 7, 2010 at 10:54 pm

    #1259912

  • RE: Select Top 1000 Suggestion

    Huh? Sure you put DESC? What you describe is what you'll get if you omit the DESC (then it sorts oldest-newest)

    Otherwise post table defs and sample data.

    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

    December 7, 2010 at 3:37 pm

    #1259847

  • RE: Select Top 1000 Suggestion

    CREATE VIEW LastEnteredRecords

    AS

    SELECT TOP (1000) ...

    FROM SomeTable

    ORDER BY <column containing date row inserted> DESC

    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

    December 7, 2010 at 3:11 pm

    #1259839

  • RE: Are the posted questions getting worse?

    Just be aware that fox is another of those 'interesting' people we have around here. Check posting history.

    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

    December 7, 2010 at 3:07 pm

    #1259838

  • RE: 2005 on 2008(OS)

    Is the server configured to allow remote connections?

    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

    December 7, 2010 at 2:12 pm

    #1259804

  • RE: Are the posted questions getting worse?

    Two that produced the 'wtf' reaction tonight...

    http://www.sqlservercentral.com/Forums/Topic1031451-391-1.aspx

    Seriously?

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

    Petty games with words and an attempt to be right?

    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

    December 7, 2010 at 2:07 pm

    #1259797

  • RE: Nonclustered Indexes

    Edit: Never mind.

    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

    December 7, 2010 at 2:03 pm

    #1259793

  • RE: Today's Random Word!

    Kit G (12/7/2010)

    Congrats Gail on surviving yet another year on Planet Earth! :w00t:

    And without murdering any project managers. Yet. :hehe:

    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

    December 7, 2010 at 1:48 pm

    #1259786

  • RE: 2005 on 2008(OS)

    Tara-1044200 (12/7/2010)

    another thing i found that though we have same version of sql 2005 but diffferent OS, we can not connect to database engine residing on 2003 OS from 2008...

    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

    December 7, 2010 at 1:41 pm

    #1259780

  • RE: Nonclustered Indexes

    SanDroid (12/7/2010)

    Although what you say is correct, your wording also seems misleading.

    Why?

    GilaMonster (12/7/2010)

    Another phrasing problem with the question - the maximum size of an index is not 900 bytes. 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

    December 7, 2010 at 1:35 pm

    #1259777

  • RE: Why doesn’t ISNUMERIC work correctly? (SQL Spackle)

    Brandie Tarvin (12/7/2010)

    Gail,

    Am I supposed to be getting an error on the Money conversion part of your code?

    Yes.

    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

    December 7, 2010 at 10:01 am

    #1259665

  • RE: Why doesn’t ISNUMERIC work correctly? (SQL Spackle)

    Craig Farrell (12/7/2010)

    steven.malone (12/7/2010)

    It shows how America-centric SQL programmers are.

    1d4 means One Pound, Four Pence in England.

    And the irony there is that Gail's from South Africa... 🙂

    And a British citizen...

    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

    December 7, 2010 at 9:59 am

    #1259659

  • RE: Today's Random Word!

    Ray K (12/7/2010)

    GilaMonster (12/7/2010)

    Mine.

    Isn't it rude to ask age? 😉

    Oh, I'm aware! But I seem to be in a rude mood this morning! :-D:hehe:

    🙂

    34. Not so old that I'm...

    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

    December 7, 2010 at 9:53 am

    #1259648

  • RE: Are the posted questions getting worse?

    Marinade chops in mix of olive oil, garlic, little dark brown sugar, dash of rum for couple hours. Grill, serve topped with cashew nuts alongside coconut rice (rice cooked...

    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

    December 7, 2010 at 9:45 am

    #1259636

  • RE: Data base mirroring

    Did you try any of Adam's advice?

    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

    December 7, 2010 at 9:35 am

    #1259623

Viewing 15 posts - 28,981 through 28,995 (of 49,552 total)