Forum Replies Created

Viewing 15 posts - 38,536 through 38,550 (of 49,552 total)

  • RE: How to distinguish SQL Server Express from SQL Server standard/enterprise

    SELECT SERVERPROPERTY ('EngineEdition') Will return one of 'Standard','Enterprise','Express'.

    Developer, Enterprise and Enterprise evaluation all return 'Enterprise'. Standard and Workgroup return 'Standard' and Express, Express with Advanced Services, and Windows Embedded SQL...

    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 9, 2009 at 3:50 pm

    #1007102

  • RE: Forums on your Resume/CV

    jcrawf02 (6/9/2009)

    Someday I'll learn how to write English that actually makes sense. What I was trying to say was that you could potentially find someone you were interviewing in SA...

    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 9, 2009 at 3:34 pm

    #1007095

  • RE: O(n) , O(n log n), O(n^2)

    karthikeyan (6/9/2009)

    output of O(n) ?

    output of O(n^2). It is 15.

    They aren't formulas to have values plugged into and results calculated. They are descriptions of the time-complexity of algorithms.

    To say that...

    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 9, 2009 at 3:19 pm

    #1007087

  • RE: Unable to restore Differential backup

    djjwu (6/9/2009)

    Any full or diff backup will block tlog backup.

    Not in SQL 2005 or above they do not.

    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 9, 2009 at 2:49 pm

    #1007065

  • RE: Multiple Single Drives vs RAID solutions?

    What RAID gets you that single drives don't is redundancy. With the appropriate RAID level, you could have one or more drives fail and have the server still working. With...

    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 9, 2009 at 2:08 pm

    #1007042

  • RE: Unable to restore Differential backup

    usman.tanveer (6/9/2009)

    The problem with mirroring would be, in HA mode it will not commit the transaction on primary untill commited on secondary, which could be a performance hit as 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 9, 2009 at 2:05 pm

    #1007041

  • RE: Are the posted questions getting worse?

    Jeff Moden (6/9/2009)

    GilaMonster (6/9/2009)

    Gee Barry

    RBarryYoung (6/9/2009) Big-O notation categorizes an algorithm's complexity in terms of the dominant term (without any constant factors) of its execution run-time as a function of...

    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 9, 2009 at 12:31 pm

    #1006989

  • RE: Are the posted questions getting worse?

    RBarryYoung (6/9/2009)

    Yeah, sorry. :blush: In my defense, I did say that it was "simple once you understood it, but hard to explain" and I did tell him to follow...

    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 9, 2009 at 12:27 pm

    #1006987

  • RE: Index question for the guru's out there...

    From experience I've found that fixing the 3 top performance problems in the DB often provides an incredible improvement in overall response and performance

    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 9, 2009 at 12:20 pm

    #1006985

  • RE: Unable to restore Differential backup

    Steve Jones - Editor (6/9/2009)

    Diffs don't impact log backups. At least I didn't think they did. They only reduce the number of log restores needed, but AFAIK (correct me Gail),...

    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 9, 2009 at 12:18 pm

    #1006983

  • RE: Should you use your full name as a username?

    Grant Fritchey (6/9/2009)

    The key to using a nickname is to use it everywhere. You just need to have an accessible association point so everyone knows that "SQL Hottie" or whatever...

    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 9, 2009 at 11:33 am

    #1006941

  • RE: Should you use your full name as a username?

    I don't think it matters much. Unless you're very careful pseudonym's not going to hide who you are. Just need one place that links pseudonym with real name. If 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

    June 9, 2009 at 11:26 am

    #1006935

  • RE: SSL option

    Krasavita (6/9/2009)

    Thank you,but how can I find out if it is already installed

    If what's installed? Books Online?

    Start - Programs - Microsoft SQL Server - Documentation and Tutorials - Books Online

    If...

    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 9, 2009 at 11:24 am

    #1006929

  • RE: Unable to restore Differential backup

    How much data can you afford to lose in the case of a disaster? That's the main question that identifies the frequency for log backups.

    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 9, 2009 at 11:12 am

    #1006908

  • RE: Are the posted questions getting worse?

    Gee Barry

    RBarryYoung (6/9/2009) Big-O notation categorizes an algorithm's complexity in terms of the dominant term (without any constant factors) of its execution run-time as a function of the length of...

    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 9, 2009 at 11:11 am

    #1006904

Viewing 15 posts - 38,536 through 38,550 (of 49,552 total)