Forum Replies Created

Viewing 15 posts - 21,796 through 21,810 (of 49,552 total)

  • RE: corrupt going from 2000 to 2008

    Sorry, no time today to sit and work on this. It's not a quick thing to work out.

    We have to delete the orphaned rows, delete the wrong ones and stuff...

    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 9, 2011 at 2:15 pm

    #1419629

  • RE: Are the posted questions getting worse?

    Kiara (12/9/2011)

    GilaMonster (12/9/2011)

    It seemed to be, because

    Surname BETWEEN @Letter + '%' ...

    and

    Surname BETWEEN CAST(@Letter AS Varchar(50)) + '%' ...

    produced different results. Didn't spend weeks investigating though...

    Hm... that would imply...

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

    #1419484

  • RE: Are the posted questions getting worse?

    It seemed to be, because

    Surname BETWEEN @Letter + '%' ...

    and

    Surname BETWEEN CAST(@Letter AS Varchar(50)) + '%' ...

    produced different results. Didn't spend weeks investigating though...

    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 9, 2011 at 9:07 am

    #1419478

  • RE: Are the posted questions getting worse?

    Cadavre (12/9/2011)

    Shows that Kiara's assessment is correct, so is there another reason it fails?

    CHAR(1). Concatenate '%' to a char(1) that holds 'A' and it gets silently dropped. So that resulted...

    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 9, 2011 at 8:57 am

    #1419463

  • RE: Plain English Translation of Index Question

    In the key != guaranteed a seek. You can only seek on a left-based subset of the index key.

    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 9, 2011 at 8:39 am

    #1419436

  • RE: #table OWNER

    You are, I assume, aware that shrinking TempDB without completely and totally quiescing the server can cause corruption that will require a restart to fix?

    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 9, 2011 at 8:35 am

    #1419431

  • RE: Plain English Translation of Index Question

    Ninja's_RGR'us (12/9/2011)

    SELECT * FROM #t WHERE a = 1 AND b = 2 AND c = 3

    --Ix Seek

    Seek and secondary filter. It can't just seek.

    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 9, 2011 at 8:34 am

    #1419430

  • RE: #table OWNER

    chauchs (12/9/2011)

    Arfff !!! :doze:

    Thx, but this is not the answer that I was hoping

    Sorry, but it's how it is

    Does the value after the '_' represents something (in the name in...

    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 9, 2011 at 8:18 am

    #1419413

  • RE: Are the posted questions getting worse?

    Kiara (12/9/2011)

    Oh, I dunno... Maybe the fact that Zyl sorts *after* Z%? 😛 Been there, written that, laughed at myself afterwards... 🙂

    No, that's actually not 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

    December 9, 2011 at 8:17 am

    #1419412

  • RE: Plain English Translation of Index Question

    rmechaber (12/9/2011)

    they can be returned with a query (eliminating the need for a bookmark lookup, if all the columns requested are included; i.e., the index is "covering" for the query),...

    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 9, 2011 at 8:02 am

    #1419393

  • RE: #table OWNER

    Not directly.

    You can see how much tempDB space is used by each connection via sys.dm_db_session_space_usage, but you can't like a temp table name back to a session_id.

    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 9, 2011 at 8:00 am

    #1419391

  • RE: The Employment Contract

    Steve Jones - SSC Editor (12/9/2011)

    IceDread (12/9/2011)

    Well.. I would probably had said no a year ago.

    This year however, my boss told me he was thinking about having me take...

    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 9, 2011 at 7:51 am

    #1419385

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (12/9/2011)

    DUH!Code

    Code written by an experienced developer that defies all pre-existing code standards and the dev's knowledge skills by believing it can do something the developer knows is impossible.

    Example:...

    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 9, 2011 at 7:45 am

    #1419379

  • RE: Rollback data

    prashant-507002 (12/9/2011)

    I think there are some hidden command in sql server which Microsoft not make it public.

    There are lots of hidden commands in SQL Server that Microsoft doesn't make public....

    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 9, 2011 at 7:41 am

    #1419375

  • RE: Rollback data

    Cadavre (12/9/2011)

    prashant-507002 (12/9/2011)

    I think i have to post support ticket to microsoft for the same.

    Who will tell you that you need to restore your database somewhere, then copy the 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 9, 2011 at 7:28 am

    #1419359

Viewing 15 posts - 21,796 through 21,810 (of 49,552 total)