Forum Replies Created

Viewing 15 posts - 30,781 through 30,795 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (9/10/2010)

    One may wonder the same about you popping in on a friday night 😉

    Finished a 3-hour game of Settlers and checking mail before crashing in front of the TV...

    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

    September 10, 2010 at 2:06 pm

    #1219483

  • RE: sql executive time question

    Ow! Why are you using Nolock? Is potentially incorrect data acceptable?

    Why are you forcing an index? Are you absolutely 100% sure that you know better than the query optimiser?

    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

    September 10, 2010 at 2:01 pm

    #1219477

  • RE: Finding the wait resource from the sys.dm_exec_requests DMV

    Depends what type the wait resource is. If it's a key, you could parse the value apart and join to the relevant system table, same if the resource is a...

    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

    September 10, 2010 at 1:58 pm

    #1219474

  • RE: Physical location of foreign keys

    Indianrock (9/10/2010)

    But foreign keys??? They don't seem to have their own storage area as viewed from sql 2008 management studio (we're still using sql 2005), so these are...

    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

    September 10, 2010 at 1:56 pm

    #1219471

  • RE: Creating a View using IF statements

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic984072-149-1.aspx

    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

    September 10, 2010 at 1:55 pm

    #1219467

  • RE: Are the posted questions getting worse?

    Gees guys... It's friday night. Don't you have anything better to do?

    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

    September 10, 2010 at 1:53 pm

    #1219464

  • RE: database mirroring

    Please note: 2 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

    September 10, 2010 at 1:53 pm

    #1219463

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (9/10/2010)

    Somebody should post dbcc timewarp on Connect 😉

    Maybe mention it to the SQL team at Summit in Feb?

    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

    September 10, 2010 at 9:06 am

    #1219263

  • RE: Common questions asked in SQL Server DBA Interview

    New questions in a new thread please, and be specific if possible

    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

    September 10, 2010 at 9:05 am

    #1219262

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (9/10/2010)

    Grant Fritchey (9/10/2010)

    GilaMonster (9/10/2010)

    Jeff Moden (9/10/2010)

    I don't have the time to read many books but that was a good one.

    Title? Author?

    Here you go. First in a trilogy. Ancient...

    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

    September 10, 2010 at 8:31 am

    #1219216

  • RE: Are the posted questions getting worse?

    Jeff Moden (9/10/2010)

    I don't have the time to read many books but that was a good one.

    Title? Author?

    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

    September 10, 2010 at 7:47 am

    #1219163

  • RE: system table page corruption

    John Liu-329005 (9/10/2010)

    Thanks Gail, Paul Randal demoed fix a system table corruption (user partially deleted record from system table in SQL2000 db)

    Yup, that's for when there just a missing reference...

    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

    September 10, 2010 at 7:47 am

    #1219161

  • RE: DBCC SHRINKFILE not working for datafile

    isheej (9/10/2010)

    If the objective is to regain space, you must not rebuild after shrink, no matter what percentage fragmentation.

    But then you're stuck with very poor performance for range scans....

    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

    September 10, 2010 at 7:42 am

    #1219153

  • RE: DBCC SHRINKFILE not working for datafile

    isheej (9/10/2010)

    Tables on heap shrink row-by-row which is painfully slow.

    No it does not. Shrink works on pages and extents. It does not change the fullness of pages. It does not...

    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

    September 10, 2010 at 7:37 am

    #1219149

  • RE: system table page corruption

    The only way you are going to recover from this is to restore from a clean backup. If you don't have a clean backup, then the only remaining possibility is...

    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

    September 10, 2010 at 6:23 am

    #1219118

Viewing 15 posts - 30,781 through 30,795 (of 49,552 total)