Forum Replies Created

Viewing 15 posts - 37,426 through 37,440 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    Interestingly enough, here the shorter the reg plate, the more you pay. So if I wanted "I GP" (Gauteng Province), I'd be paying R3800. If I wanted "I WP" (Western...

    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

    July 26, 2009 at 4:33 am

    #1030268

  • RE: how to check whether the query is doing a table scan or index scan

    Saurabh Aggarwal (7/26/2009)

    For eg if i am troubleshooting the slowmess of spid 55, which is still in running state and app team is saying that query taking long time...

    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

    July 26, 2009 at 4:33 am

    #1030267

  • RE: how to check whether the query is doing a table scan or index scan

    Actually, you can get the plan of a query that has been run by the app or another user, providing the execution plan for that query is still in cache.

    SELECT...

    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

    July 26, 2009 at 3:41 am

    #1030262

  • RE: Does Maturity Make a DBA?

    I suspect you're going to get a lot of hate mail for this one Brad.... 😉

    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

    July 26, 2009 at 3:25 am

    #1030261

  • RE: Are the posted questions getting worse?

    Prices here range from R10 000 to R550, depending exactly what you ask for and what province you are in.

    ITDPNDS may not be allowed in the US, but it 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

    July 26, 2009 at 3:11 am

    #1030258

  • RE: Possible Data corruption ?

    You've got data corruption and it looks like very nasty corruption.

    There's damage to one of the system tables and that is not repairable in any way. Do you have...

    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

    July 25, 2009 at 2:05 pm

    #1030206

  • RE: Urgert [server error occured ]

    Please run this 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

    July 25, 2009 at 2:00 pm

    #1030205

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (7/25/2009)

    ITDPNDS

    That one has to be for Paul or Kimberly.

    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

    July 25, 2009 at 1:40 pm

    #1030203

  • RE: Are the posted questions getting worse?

    Jan Van der Eecken (7/25/2009)

    GilaMonster (7/24/2009)

    Jan Van der Eecken (7/24/2009)

    On the way home there was a silver Audi A4 2.T driving in front of me whose owner's ego may well...

    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

    July 25, 2009 at 1:32 pm

    #1030202

  • RE: SQL Database Problem

    How did the database get detached?

    Do you have a backup?

    The recommended solution here is to restore from a clean backup. If you have no backup (why?) then we're going to...

    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

    July 25, 2009 at 2:22 am

    #1030122

  • RE: Which on is the Best option???

    Lynn Pettis (7/24/2009)

    My concerns regard both is the possibility of extraneous data returned based on the joins.

    Yeah. That's one very strange join condition.

    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

    July 24, 2009 at 3:12 pm

    #1030070

  • RE: Are the posted questions getting worse?

    Jan Van der Eecken (7/24/2009)

    Just like Gail and her neighbours will most likely have a GP (Gauteng Province) at the end of theirs.

    Gangster's Paradise. :unsure:

    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

    July 24, 2009 at 3:05 pm

    #1030068

  • RE: Are the posted questions getting worse?

    Jan Van der Eecken (7/24/2009)

    On the way home there was a silver Audi A4 2.T driving in front of me whose owner's ego may well be slightly overinflated. Personalised license...

    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

    July 24, 2009 at 3:03 pm

    #1030067

  • RE: Error with Syntax in Case statement

    Are you trying to change the value of another column in the table? If so, you need the UPDATE statement.

    If not, can you give us some sample data and what...

    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

    July 24, 2009 at 12:45 pm

    #1029979

  • RE: Which on is the Best option???

    Why don't you try them both and see?

    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

    July 24, 2009 at 12:44 pm

    #1029978

Viewing 15 posts - 37,426 through 37,440 (of 49,552 total)