Forum Replies Created

Viewing 15 posts - 8,806 through 8,820 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (6/8/2014)

    Wut? This seems inbelievable.

    Not the first time I've seen that kind of thing from that person.

    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

    June 9, 2014 at 2:21 am

    #1720012

  • RE: When criteria in the where clause result is different than the same criteria in the on clause. Why?

    http://www.sqlskills.com/blogs/kimberly/determining-the-position-of-search-arguments-in-a-join/

    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

    June 8, 2014 at 10:00 am

    #1719967

  • RE: Just curious, what are your SQL pet peeves ?

    Luis Cazares (6/6/2014)

    djj (6/6/2014)

    An expert converted our database from Access to SQL2000. We now have zip codes that are float, column names with spaces and #.

    That's why...

    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

    June 6, 2014 at 12:35 pm

    #1719806

  • RE: Need to Create Partition to an existing Table

    Still haven't got an answer to why the table is being partitioned in the first place. What's the point?

    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

    June 6, 2014 at 12:29 pm

    #1719805

  • RE: restore .mdf, then apply logs / point in time

    dough-378918 (6/6/2014)

    Any thoughts on how to apply a .mdf and then apply the .bak files?

    You don't.

    Copies of the mdf and ldf are not backups. To restore point 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

    June 6, 2014 at 8:31 am

    #1719693

  • RE: Interview Questions

    kimberly_lehman (6/6/2014)

    I saw you mentioned that, but I would have had to Google whether an update trigger fires once per update or once per row.

    All SQL triggers fire per operation....

    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

    June 6, 2014 at 8:02 am

    #1719680

  • RE: Are the posted questions getting worse?

    patrickmcginnis59 10839 (6/6/2014)

    GilaMonster (6/6/2014)

    patrickmcginnis59 10839 (6/5/2014)

    I'm going to be honest with you, as far as 2014 memory optimized tables(?) go, I don't know what standard behavior even is. I sure...

    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

    June 6, 2014 at 7:52 am

    #1719674

  • RE: Truncation of transaction log

    sybrand (6/6/2014)

    This is the Important part and the way to shrink the Transaction log is to set the Recovery to Simple in properties, then go to Shrink File and 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

    June 6, 2014 at 7:47 am

    #1719669

  • RE: Deadlock seems to involve only one object.

    Well, the deadlocks by example article is only 6 months old, so not all that many intervening years. 🙂

    It's not a single transaction deadlock, there are two processes, so two...

    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

    June 6, 2014 at 7:42 am

    #1719663

  • RE: WITH(NOLUCK)

    sqldriver (6/6/2014)

    GilaMonster (6/6/2014)

    pietlinden (6/5/2014)

    If you dig around here even a little, you'll find Gail Shaw's explanation of what NOLOCK really does. You might need to make them read 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

    June 6, 2014 at 4:57 am

    #1719605

  • RE: Identity column gaps -- time based?

    SQL 2008 (as per the forum) or SQL 2012?

    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

    June 6, 2014 at 4:15 am

    #1719596

  • RE: WITH(NOLUCK)

    pietlinden (6/5/2014)

    If you dig around here even a little, you'll find Gail Shaw's explanation of what NOLOCK really does. You might need to make them read the article she...

    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

    June 6, 2014 at 4:13 am

    #1719594

  • RE: WITH(NOLUCK)

    MyDoggieJessie (6/6/2014)

    Ummm. RCSI? What's that?

    Read-Committed Snapshot Isolation

    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

    June 6, 2014 at 4:09 am

    #1719593

  • RE: Are the posted questions getting worse?

    patrickmcginnis59 10839 (6/5/2014)

    I'm going to be honest with you, as far as 2014 memory optimized tables(?) go, I don't know what standard behavior even is. I sure hope it isn't...

    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

    June 6, 2014 at 12:54 am

    #1719550

  • RE: SQL Server 2008

    As I said, I'd be looking for external memory pressure when that happens.

    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

    June 6, 2014 at 12:43 am

    #1719547

Viewing 15 posts - 8,806 through 8,820 (of 49,552 total)