Forum Replies Created

Viewing 15 posts - 25,531 through 25,545 (of 49,552 total)

  • RE: Backup Duration

    And what does dbo.BackupDB do?

    From the backup output it's clear there's more than simply a backup.

    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 13, 2011 at 3:58 pm

    #1338086

  • RE: Today's Random Word!

    Tom.Thomson (6/13/2011)

    If transport companies means companies that transport parcels/packages and other goods, it's probably impossible for their data do do as much harm as their appalling customer service so data...

    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 13, 2011 at 1:38 pm

    #1338033

  • RE: SQL Server 2008 bit field best design practices

    You can index a bit, no problem (the myth that you can't is because the SQL 2000 Enterprise Manager wouldn't allow it, but the database engine has no such problems).

    Indexing...

    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 13, 2011 at 1:12 pm

    #1338016

  • RE: Nonclustered Indexes

    Maybe take a read through these articles...

    http://www.sqlservercentral.com/articles/Indexing/68439/

    http://www.sqlservercentral.com/articles/Indexing/68636/

    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 13, 2011 at 1:10 pm

    #1338014

  • RE: Today's Random Word!

    Tom.Thomson (6/13/2011)

    GilaMonster (6/13/2011)

    Data integrity (as in 'What data integrity?')

    That would perhaps be "data integrity" as in "all the data is integral" (even the strings, floating point numbers, and GUIDs) :w00t:

    Or...

    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 13, 2011 at 12:57 pm

    #1338004

  • RE: Backup Duration

    Are there other things in that job step? A verify perhaps? CheckDB? Another backup?

    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 13, 2011 at 12:46 pm

    #1337989

  • RE: Today's Random Word!

    Data integrity (as in 'What data integrity?')

    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 13, 2011 at 12:38 pm

    #1337983

  • RE: Missing Transaction Log

    Excellent.

    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 13, 2011 at 12:14 pm

    #1337962

  • RE: Missing Transaction Log

    Did you miss the step that said to switch the database to emergency mode?

    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 13, 2011 at 12:03 pm

    #1337956

  • RE: 70-433 - With Encryption Question

    jarid.lawson (6/13/2011)

    I'm not sure I follow you completely. Are you saying that other users would not be able to see the list of field names, data types, etc. for 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

    June 13, 2011 at 11:19 am

    #1337925

  • RE: Log File Space during Updates of a Table

    Grizzly Bear (6/13/2011)

    There was also a Trigger which would write to another table, which is at the bottom for every row updated.

    Which means you need to account for that 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

    June 13, 2011 at 11:16 am

    #1337923

  • RE: 70-433 - With Encryption Question

    It obfuscates the storage of the definition in the system tables (it is not encryption, despite the name). It's pretty easy to undo, so it's not going to stop someone...

    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 13, 2011 at 10:12 am

    #1337882

  • RE: Are the posted questions getting worse?

    ALZDBA (6/13/2011)

    Steve Jones - SSC Editor (6/13/2011)

    Our "real world financial problem" individual sent me a note that he got a "real answer" on the MSDN forums.

    He ignored the fact...

    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 13, 2011 at 9:57 am

    #1337869

  • RE: Why should I run update statistics after rebuilding the indexes on a table?

    I live to anticipate. 😀

    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 13, 2011 at 9:49 am

    #1337860

  • RE: Why should I run update statistics after rebuilding the indexes on a table?

    You shouldn't.

    What you may need to do is update the column statistics (ones not associated with indexes) as they would not have been updated by index rebuilds.

    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 13, 2011 at 9:45 am

    #1337856

Viewing 15 posts - 25,531 through 25,545 (of 49,552 total)