Forum Replies Created

Viewing 15 posts - 10,831 through 10,845 (of 49,552 total)

  • RE: MINIMUM & MAXIMUM Memory in SQL 2012

    https://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/ - Chapter 4

    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 26, 2013 at 2:10 am

    #1669053

  • RE: data file increase after index rebuild

    Normal, fully expected. SQL needs space to put the new index. A rebuild creates the new index then drops the old. So if there wasn't space in the data file...

    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 25, 2013 at 9:35 am

    #1668874

  • RE: ALTER TABLE ALTER COLUMN question

    Not true. You can wrap expressions in as many brackets as you like, makes no difference.

    p.s. 3 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

    November 25, 2013 at 9:33 am

    #1668872

  • RE: Backup Time vs Restore Time

    _nzrdb6 (11/25/2013)

    I'm being asked to estimate restore time where backup time will be around 2hrs in total across a number of DBs.

    Restore the database, see how long it takes. Best...

    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 25, 2013 at 9:32 am

    #1668870

  • RE: CHECKDB Error

    sreekanth bandarla (11/25/2013)

    OFFLINE INDEX REBUILD should work fine....Online index rebuild reads the old index to build the new one so the new index has the same missing rows as 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

    November 25, 2013 at 9:26 am

    #1668862

  • RE: Managing Transaction Logs

    Straight from the article

    Frequency of log backups

    The frequency that log backups should be done is dependent on two considerations:

    The maximum amount of data that 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

    November 25, 2013 at 9:24 am

    #1668859

  • RE: CHECKDB Error

    Ratheesh.K.Nair (11/25/2013)

    As mentioned in earlier post the solution is to drop and recreate the index and as far as i know its same as Rebuild but Rebuild wont fix 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

    November 25, 2013 at 9:23 am

    #1668858

  • RE: Managing Transaction Logs

    Tran log backups are unaffected by full/diff backups, so you can have your tran log backups running before, during or after the full/diff.

    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 25, 2013 at 8:31 am

    #1668833

  • RE: 8KB page size

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

    November 25, 2013 at 1:27 am

    #1668732

  • RE: UniqueIdentifier Type

    mah_j (11/24/2013)

    Now this field does not have a default of NEWID(),and the value for this column is generated automatically,not in the application,so as I understood from your reply, if...

    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 25, 2013 at 1:19 am

    #1668731

  • RE: Migrate a SQL 2000 database to a different server

    http://technet.microsoft.com/en-us/library/bb510680%28v=sql.105%29.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

    November 24, 2013 at 1:41 pm

    #1668685

  • RE: UniqueIdentifier Type

    mah_j (11/24/2013)

    Why should it ignore the default?You mean again it inserts a random data not bigger one?

    If an insert explicitly specifies a value for a column that has a default,...

    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 24, 2013 at 12:08 pm

    #1668674

  • RE: fragmentation question

    Better term for that is 'low page density'.

    Inserts and updates can cause page splits, which results in pages half full. Deletes can leave empty gaps on pages where 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

    November 24, 2013 at 12:05 pm

    #1668673

  • RE: fragmentation question

    Depends what the book means by 'internal fragmentation'. It's a poorly defined term that has been used for different things by different people.

    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 24, 2013 at 6:06 am

    #1668649

  • RE: UniqueIdentifier Type

    It's the same data type. No idea if it'll even work. If you specify a default and the app explicitly inserts a value, the default is ignored.

    Better option would 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

    November 24, 2013 at 6:05 am

    #1668648

Viewing 15 posts - 10,831 through 10,845 (of 49,552 total)