Forum Replies Created

Viewing 15 posts - 20,956 through 20,970 (of 49,552 total)

  • RE: Hi all

    In short, the answers to your questions are:

    1) Not enough information

    2) Not enough information

    3) Not enough information

    A full backup will be the size of the data

    A differential backup will be...

    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

    January 18, 2012 at 3:56 am

    #1435100

  • RE: DBCC CHECKDB

    MasterDB (1/18/2012)

    I've not created or automated any job to do run DBCC CHECKDB. But i noticed that DBCC CHECKDB is running on daily basis.

    Why do you think it's running daily?

    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

    January 18, 2012 at 3:55 am

    #1435098

  • RE: Does Table Value function caches execution plan?

    Anamika (1/17/2012)

    thanks Fritchey,

    small set of value means may i take it as less than 100 rows or 500-1000 rows?

    Sometimes even 1 row is too many.

    with the current execution plan can...

    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

    January 18, 2012 at 3:51 am

    #1435097

  • RE: Sql Server 2005 DataBase is Down

    Down or slow? Down usually means unavailable, in which case performance tuning isn't going to help. If you mean slow, read these

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

    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

    January 17, 2012 at 3:18 pm

    #1434903

  • RE: ReFS (Resilient File System) and SQL

    This is probably the most available at the moment:http://itknowledgeexchange.techtarget.com/sql-server/windows-8-refs-and-sql-server/

    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

    January 17, 2012 at 2:14 pm

    #1434875

  • RE: can anyone pls help with this error in restore database

    What command are you running?

    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

    January 17, 2012 at 12:01 pm

    #1434779

  • RE: Replacing Index Scan with Index Seek

    I've probably missed something, but I see table, indexes, data, but I don't see a query.

    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

    January 17, 2012 at 12:00 pm

    #1434777

  • RE: DBAs and the Career-Life Balance

    TravisDBA (1/17/2012)

    butler-628023 (1/16/2012)

    The pastor who performed my marriage and counseled my wife and I before the blessed event gave me this wise advice...Put family events (i.e. commitments) in your planner...

    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

    January 17, 2012 at 9:58 am

    #1434714

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (1/17/2012)

    SQLRNNR (1/17/2012)

    There's that, and some big money at stake. Somebody is also probably up for re-election or out to make a big name 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

    January 17, 2012 at 9:50 am

    #1434705

  • RE: Are the posted questions getting worse?

    The quote is from a filesystem-related blog, mentioning the file system features that the new ReFS won't support

    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

    January 17, 2012 at 9:29 am

    #1434693

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (1/17/2012)

    And no Sparse? That extends to SQL Server? They just added that! I have it all over my tables.

    Errr... No Sparse files (which is what snapshots use).

    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

    January 17, 2012 at 9:20 am

    #1434685

  • RE: Transaction Log Backup Naming/ Strategy Question

    ragresti-1141020 (1/17/2012)

    This way there would only be one log backup to restore in the event of failure.

    No, there won't be just one log backup to restore. You'll have just as...

    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

    January 17, 2012 at 9:16 am

    #1434681

  • RE: Are the posted questions getting worse?

    Oh this is fun...

    http://itknowledgeexchange.techtarget.com/sql-server/windows-8-refs-and-sql-server/

    Quoting from a post that article references (http://blogs.msdn.com/b/b8/archive/2012/01/16/building-the-next-generation-file-system-for-windows-refs.aspx)

    Q) What semantics or features of NTFS are no longer supported on ReFS?

    ...

    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

    January 17, 2012 at 8:35 am

    #1434657

  • RE: DBAs and the Career-Life Balance

    TravisDBA (1/17/2012)

    GilaMonster (1/17/2012)

    TravisDBA (1/17/2012)

    I once was interviewed by Citrix and the Cambodian that interviewed me told me "We work hard, but we play hard too." Which my response was "What...

    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

    January 17, 2012 at 8:16 am

    #1434638

  • RE: DBAs and the Career-Life Balance

    TravisDBA (1/17/2012)

    I once was interviewed by Citrix and the Cambodian that interviewed me told me "We work hard, but we play hard too." Which my response was "What exactly does...

    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

    January 17, 2012 at 8:01 am

    #1434623

Viewing 15 posts - 20,956 through 20,970 (of 49,552 total)