Forum Replies Created

Viewing 15 posts - 19,171 through 19,185 (of 49,552 total)

  • RE: How does one force a column (which is not the PK) to be unique?

    Maybe explain why you want to force something that is not naturally unique to be unique?

    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

    April 12, 2012 at 9:44 am

    #1472705

  • RE: Question on bloated Transaction Log after doing index maintenance.

    The log will not continue to grow unless you have something else wrong.

    Please read through this: http://www.sqlservercentral.com/articles/Transaction+Log/72488/

    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

    April 12, 2012 at 9:42 am

    #1472702

  • RE: Question on bloated Transaction Log after doing index maintenance.

    Greg.Jackson (4/12/2012)

    So here's my question. Should I add some steps to the job to alter the recovery model to simple and shrink the log file, then back to full recovery...

    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

    April 12, 2012 at 9:11 am

    #1472666

  • RE: Designing a database for a tennis league

    kranthi.india123 (4/12/2012)

    definatly i will paid to you for these things

    You might want to ask Grant's rate before you offer to pay him...

    i know but data modlelings and design pattens i...

    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

    April 12, 2012 at 8:37 am

    #1472626

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (4/12/2012)

    Brandie Tarvin (4/11/2012)

    GilaMonster (4/10/2012)

    Brandie Tarvin (4/10/2012)

    Oddly enough, that captcha came up when I was doing something at one of my writer association sites.

    On that point, do 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

    April 12, 2012 at 7:32 am

    #1472567

  • RE: Faultfinding possible I/O issues

    If the secondary has gone suspect and the primary is fine, then it's the secondary's IO subsystem that's the problem.

    Start with the windows error log, any RAID logs, SAN...

    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

    April 12, 2012 at 6:19 am

    #1472511

  • RE: How database grows?

    DBCC IND doesn't show pages. It lists which pages belong to which objects. To view pages, you use DBCC Page. That can view any allocated or unallocated page anywhere 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

    April 12, 2012 at 5:44 am

    #1472499

  • RE: How database grows?

    Thinky Night (4/12/2012)

    If there is a mixed extent, Must it contain a Shared Global Allocation Map (SGAM) Page and Page Free Space (PFS) Page?

    No, not if one already exists for...

    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

    April 12, 2012 at 5:22 am

    #1472483

  • RE: Abnormal SQL issue

    tt-615680 (4/12/2012)

    I was thinking of creating another user with a similar privileges as the SysAmin user but what would be the advantage of creating yet another user, which would eventually...

    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

    April 12, 2012 at 4:47 am

    #1472464

  • RE: How database grows?

    When a database is created, it's a specific size (the size of Model or the size you specified)

    First page allocated from a new table, SQL will look for a mixed...

    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

    April 12, 2012 at 4:43 am

    #1472460

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (4/12/2012)

    Speaking of brains, does anyone have one to spare?

    Sorry, mine's just declared the rest of the day to be a do-nothing day due to overwork.

    Dragon Age, Mass...

    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

    April 12, 2012 at 4:42 am

    #1472459

  • RE: CAREER ADVICE: Applying for DBA Jobs?

    Henrico Bekker (4/12/2012)

    for your question on the ML pages -> Nasty....do they ever take a guess? 25, 125, 1025? do they ever mention BL mode for ML Pages? would love...

    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

    April 12, 2012 at 4:38 am

    #1472456

  • RE: Estimated Execution Plan.

    Because run-time information is not stored with the plan in cache. It can't be. If the plan was executed 10 times, which execution's run-time information would be included with 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

    April 12, 2012 at 4:32 am

    #1472449

  • RE: CAREER ADVICE: Applying for DBA Jobs?

    Henrico Bekker (4/12/2012)

    When I used to interview someone, I would ask one unanswerable question

    I've done it as well... "how do you detach a Log Shipped tempdb that is in Read...

    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

    April 12, 2012 at 4:23 am

    #1472447

  • RE: CAREER ADVICE: Applying for DBA Jobs?

    I'll second the 'never bluff your way through an interview' statement. Doesn't work with an interviewer who knows the field.

    When I used to interview someone, I would ask one unanswerable...

    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

    April 12, 2012 at 12:36 am

    #1472394

Viewing 15 posts - 19,171 through 19,185 (of 49,552 total)