Forum Replies Created

Viewing 15 posts - 8,266 through 8,280 (of 49,552 total)

  • RE: lock acquisition order in sp_lock

    You need the lock acquired event.

    Do NOT do that on a production server, that's a high-volume event, it can have severe impact on the server if it's already under any...

    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

    August 5, 2014 at 4:56 am

    #1735092

  • RE: lock acquisition order in sp_lock

    No, they're not.

    If you want to see the order, try a profiler trace or extended events (and don't do that on a production DB)

    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

    August 5, 2014 at 4:22 am

    #1735075

  • RE: Shrink Db

    Please note: 5 year old thread.

    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

    August 5, 2014 at 4:20 am

    #1735072

  • RE: SQL DBA high ended question (5+ years’ experience)

    Koen Verbeeck (8/5/2014)

    GilaMonster (8/5/2014)

    Koen Verbeeck (8/5/2014)

    GilaMonster (8/5/2014)

    What do you mean? What kind of questions they'll ask in what context?

    I guess in a job interview.

    In that case, for 5+ years experience:

    Name...

    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

    August 5, 2014 at 4:17 am

    #1735067

  • RE: SQL DBA high ended question (5+ years’ experience)

    Koen Verbeeck (8/5/2014)

    GilaMonster (8/5/2014)

    What do you mean? What kind of questions they'll ask in what context?

    I guess in a job interview.

    In that case, for 5+ years experience:

    Name 3 backup types...

    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

    August 5, 2014 at 2:25 am

    #1735030

  • RE: SQL DBA high ended question (5+ years’ experience)

    What do you mean? What kind of questions they'll ask in what context?

    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

    August 5, 2014 at 2:19 am

    #1735028

  • RE: Breaking the backup-chain or backup sequence in SQL Server?

    MikaS (8/5/2014)

    What I wanted to say is that if someone takes a Full backup outside the regular backup schedule without using the COPY_ONLY, there's a possibility of ending up 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

    August 5, 2014 at 2:19 am

    #1735027

  • RE: Breaking the backup-chain or backup sequence in SQL Server?

    MikaS (8/5/2014)

    - Using 3rd party Backup software, not always but there's a good chance for it to happen.

    That won't break the backup chain. Can make it hell to restore 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

    August 5, 2014 at 1:01 am

    #1735008

  • RE: Breaking the backup-chain or backup sequence in SQL Server?

    To break the backup chain:

    - Switch to simple recovery and back to full

    - Delete a log backup file (the .trn)

    - Delete the transaction log

    - Revert to a snapshot

    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

    August 4, 2014 at 3:14 pm

    #1734958

  • RE: Are the posted questions getting worse?

    If the questions have worn you out, may I suggest a couple of maths limericks?

    http://iwastesomuchtime.com/on/?i=93785

    A dozen, a gross and a score

    plus three time the square root of four

    divided by seven

    plus...

    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

    August 4, 2014 at 2:59 pm

    #1734955

  • RE: Table Variable issues in Stored Procedure

    iasher (8/4/2014)

    The table referenced in the FROM clause ("attorney") is actually the source table, but it's the target table (@IA_CourtCostReport) that's causing the problem, so I'm not sure how 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

    August 4, 2014 at 10:29 am

    #1734902

  • RE: Table Variable issues in Stored Procedure

    iasher (8/4/2014)

    GilaMonster (8/4/2014)

    You need to alias table variables in the FROM, and use the aliases in the other clauses. You can't refer to @tbl.somecolumn anywhere, it's not considered valid

    Which FROM...

    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

    August 4, 2014 at 9:45 am

    #1734891

  • RE: Table Variable issues in Stored Procedure

    You need to alias table variables in the FROM, and use the aliases in the other clauses. You can't refer to @tbl.somecolumn anywhere, it's not considered valid

    btw, are table variables...

    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

    August 4, 2014 at 9:09 am

    #1734880

  • RE: Tuning a query that takes 60 minutes to run,

    rajsin7786 (8/4/2014)

    sure, just finished running the exec sp_updatestat, all stats are updated on this DB now. Running the SQL now, will keep you posted.

    No, not sp_updatestats (which does a sampled...

    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

    August 4, 2014 at 9:07 am

    #1734877

  • RE: Are the posted questions getting worse?

    jcrawf02 (8/4/2014)

    Jesus Grant, you throw this one to the OP like it's a "querying for dummies" book or something, and while I cannot disagree that reading it would give 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

    August 4, 2014 at 6:47 am

    #1734825

Viewing 15 posts - 8,266 through 8,280 (of 49,552 total)