Forum Replies Created

Viewing 15 posts - 40,771 through 40,785 (of 49,552 total)

  • RE: Retrieve original password from MD5 Hashed Password

    senyorita (2/24/2009)

    you mean to say that its impossible.

    Yup.

    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

    February 25, 2009 at 12:25 am

    #949815

  • RE: are these fields appropriate for clustered index

    chrisau168 (2/24/2009)

    What I did noticed when I did ran the reports was that the reports were still slow and after turning on stats io there were alot of logical...

    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

    February 25, 2009 at 12:22 am

    #949813

  • RE: DBCC CheckDB has failed

    No way to tell from that, as the results have been cut off. Please run the following and post the results

    DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS

    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

    February 25, 2009 at 12:21 am

    #949812

  • RE: production server slower than development server

    aravind (2/24/2009)

    Normally any company will have production server highly configured than the development server. So in that case how this could happen?

    "Production server slower than development server".

    More users and hence...

    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

    February 25, 2009 at 12:19 am

    #949811

  • RE: production server slower than development server

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

    February 25, 2009 at 12:17 am

    #949810

  • RE: production server slower than development server

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

    February 25, 2009 at 12:17 am

    #949809

  • RE: production server slower than development server

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

    February 25, 2009 at 12:17 am

    #949808

  • RE: Space Efficiency

    developer6 (2/24/2009)

    A co-worker of mine is adamant that the order of columns based on nullability is a total non-issue. Which one of us is correct?

    Your colleague...

    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

    February 24, 2009 at 10:08 am

    #949520

  • RE: Are the posted questions getting worse?

    Bob Hovious (2/24/2009)

    Gail, can I respond to the "doing things where they make sense" through an email or something? I think there is a case where it...

    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

    February 24, 2009 at 9:43 am

    #949499

  • RE: data inserting to top of table

    Mindy Hreczuck (2/24/2009)

    I have a table in which the first two entries must always be particular parameters and then after that order doesn't matter.

    Rows in a table have no defined...

    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

    February 24, 2009 at 9:42 am

    #949497

  • RE: Wrong index being used, how to get it to use the right one?

    Mindy Hreczuck (2/24/2009)

    We ended up not being able to resolve this one, and got the developer to add an index hint if it determines the requisite index exists.

    Post the exec...

    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

    February 24, 2009 at 9:40 am

    #949494

  • RE: Can not save backup file

    James Goodwin (2/24/2009)

    I would like to mention to those who are recommending a local backup first that not everyone has enough drive space on the server to hold their complete...

    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

    February 24, 2009 at 9:27 am

    #949482

  • RE: Are the posted questions getting worse?

    Bob Hovious (2/24/2009)

    The tests I ran suggest (to me anyway) that it really isn't enough extra work to worry about.

    It's not just about work. It's about doing 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

    February 24, 2009 at 9:10 am

    #949469

  • RE: Are the posted questions getting worse?

    Derek Dongray (2/24/2009)

    Maybe the posted questions have stopped getting worse and OPs are starting to ask sensible questions with well-formatted sample data?

    More likely, everyone was so busy chatting about favourite...

    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

    February 24, 2009 at 8:13 am

    #949407

  • RE: Are the posted questions getting worse?

    Derek Dongray (2/24/2009)

    That's the bit I'm not looking forward to... having to talk to a so-called tech support person who will ask me to "unplug all the phone extensions", "try...

    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

    February 24, 2009 at 8:08 am

    #949398

Viewing 15 posts - 40,771 through 40,785 (of 49,552 total)