Forum Replies Created

Viewing 15 posts - 29,551 through 29,565 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (11/4/2010)

    GilaMonster (11/4/2010)

    Gianluca Sartori (11/4/2010)

    Nothing to complain about today?

    Plenty, but I think most people are tired of hearing me whine about the Nightmare Project.

    Nah - do tell.

    Let's just say that...

    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

    November 4, 2010 at 11:49 am

    #1246736

  • RE: Transactiom / Row Level Lock?

    Um....

    GSquared (11/4/2010)

    Take a look at isolation levels in Books Online or on MSDN.com. That's about as close as you're going to get. Probably won't do what you need,...

    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

    November 4, 2010 at 11:17 am

    #1246705

  • RE: Are the posted questions getting worse?

    Gianluca Sartori (11/4/2010)

    Nothing to complain about today?

    Plenty, but I think most people are tired of hearing me whine about the Nightmare Project.

    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

    November 4, 2010 at 11:15 am

    #1246703

  • RE: Are the posted questions getting worse?

    WayneS (11/3/2010)

    Gail - do you know anything about SS2008's DBCC CHECKDB adding in checks for sys.parameters?

    Not that I know of. Maybe ask the Master (Paul Randal)?

    p.s. if the DBs were...

    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

    November 4, 2010 at 11:13 am

    #1246700

  • RE: Subquery Returns No Rows when there are NULLs and "NOT IN" is used

    GSquared (11/4/2010)

    But it is odd that the behavior is different, if you really look at the justification for Not In working the way it does. I've often wondered about...

    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

    November 4, 2010 at 8:03 am

    #1246555

  • RE: Find tables unused since last SQL Server restart

    Chris Holding (11/4/2010)

    This works for SQL 2005 and above but I'm having problems with SQL 2000; can anyone rewrite for SQL 2000?

    No, because the information is not there in SQL...

    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

    November 4, 2010 at 8:00 am

    #1246550

  • RE: Subquery Returns No Rows when there are NULLs and "NOT IN" is used

    GSquared (11/3/2010)

    The Not Exists version is very similar, and SQL Server will often convert it to a Not In query anyway, behind the scenes.

    Except it behaves differently in the presence...

    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

    November 3, 2010 at 9:43 am

    #1246115

  • RE: Change from Full to Simple Recovery, what to do with the Log file?

    Kit G (11/3/2010)

    How do I find out what percentage is getting used? Is that a DBCC command or something else? I haven't dived into the various options on...

    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

    November 3, 2010 at 9:41 am

    #1246112

  • RE: Subquery Returns No Rows when there are NULLs and "NOT IN" is used

    http://sqlinthewild.co.za/index.php/2010/02/18/not-exists-vs-not-in/

    http://sqlinthewild.co.za/index.php/2009/08/17/exists-vs-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

    November 3, 2010 at 9:34 am

    #1246102

  • RE: Change from Full to Simple Recovery, what to do with the Log file?

    Kit G (11/3/2010)

    1) If I leave things as they are, will SQL Server eventually reduce the size of the transaction log for the 15GB database? If SQL Server needs...

    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

    November 3, 2010 at 8:55 am

    #1246055

  • RE: How to find LSN numbers in Log shipping

    SKYBVI (11/3/2010)

    I think he trying to say, when log shipping is out of sync and we try to restore the transaction logs ,

    it gives error that the LSN number.....is too...

    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

    November 3, 2010 at 8:49 am

    #1246046

  • RE: Index, one index per column or per column combination?

    In addition, check out these two. I doubt that all three of the indexes in option 2 are required.

    http://sqlinthewild.co.za/index.php/2009/01/19/index-columns-selectivity-and-equality-predicates/

    http://sqlinthewild.co.za/index.php/2009/02/06/index-columns-selectivity-and-inequality-predicates/

    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

    November 3, 2010 at 7:48 am

    #1245994

  • RE: Are the posted questions getting worse?

    Jeff Moden (11/3/2010)

    GilaMonster (11/3/2010)

    ....since I won't be at PASS?

    Crap. You're one of the folks I wanted to meet.

    Sorry, I thought you knew. It's not exactly been a secret.

    You're on...

    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

    November 3, 2010 at 7:23 am

    #1245977

  • RE: Are the posted questions getting worse?

    http://pulse.sqlserverpedia.com/awards/

    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

    November 3, 2010 at 5:58 am

    #1245933

  • RE: Are the posted questions getting worse?

    Grant Fritchey (11/3/2010)

    I'd just like to win my category but this David Dye guy (never heard of him before and he's an MVP) is doing really well.

    Check again. You're 1...

    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

    November 3, 2010 at 5:54 am

    #1245931

Viewing 15 posts - 29,551 through 29,565 (of 49,552 total)