Forum Replies Created

Viewing 15 posts - 23,641 through 23,655 (of 49,552 total)

  • RE: Adding PERSISTED Computed Column = INDEX Defragmentation?

    Bear in mind, this only happens when you add the column. Not something you'll be doing every day and not much different from adding a normal column.

    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 8, 2011 at 1:21 pm

    #1378870

  • RE: Adding PERSISTED Computed Column = INDEX Defragmentation?

    codebyo (9/8/2011)

    If my clustered index's fill factor is set to 80% then 20% will be free for new rows. Adding a new column will not use that space and 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

    September 8, 2011 at 1:17 pm

    #1378869

  • RE: What would you move (in your DB ) to a new Drive If Your DB Server Got One

    The log 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

    September 8, 2011 at 12:52 pm

    #1378857

  • RE: Intellisense not working only on specific stored procedure/table combo

    Edit-> Intellisense -> Refresh Local Cache (Ctrl-Shift-R)

    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 8, 2011 at 12:51 pm

    #1378856

  • RE: Are the posted questions getting worse?

    SwayneBell (9/8/2011)

    GilaMonster (9/8/2011)

    All the sessions were recorded, they'll be up on the PASS website in a few weeks.

    That's great news Gail!

    I'm sure that you'll lose me five seconds into...

    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 8, 2011 at 12:49 pm

    #1378853

  • RE: Detach/Attach method of upgrading SQL 2000 to SQL 2008 R2

    I would still take a backup before. Paranoia is good for a DBA.

    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 8, 2011 at 12:28 pm

    #1378844

  • RE: Detach/Attach method of upgrading SQL 2000 to SQL 2008 R2

    Main drawback - there's no going back. Once the files are attached to SQL 2008 R2, you cannot more them back to SQL 2000. So if something goes wrong and...

    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 8, 2011 at 12:20 pm

    #1378837

  • RE: Restore database

    ps. (9/8/2011)

    GilaMonster (9/8/2011)

    ps. (9/8/2011)

    GilaMonster (9/8/2011)

    Restoring over an existing database that is in use? If so, the restore can't even start until exclusive access is obtained on the DB.

    SQL throws error...

    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 8, 2011 at 10:41 am

    #1378756

  • RE: Restore database

    ps. (9/8/2011)

    GilaMonster (9/8/2011)

    Restoring over an existing database that is in use? If so, the restore can't even start until exclusive access is obtained on the DB.

    SQL throws error message 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

    September 8, 2011 at 10:34 am

    #1378741

  • RE: Restore database

    Restoring over an existing database that is in use? If so, the restore can't even start until exclusive access is obtained on the DB.

    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 8, 2011 at 10:21 am

    #1378725

  • RE: plz help me

    SQL doesn't have logical backups.

    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 8, 2011 at 9:25 am

    #1378650

  • RE: Differential and log backups fail after full backup

    krishna.vanne (9/8/2011)

    Once a full backup w/o copy only option is issue and even though the backup is deleted and then a new backup with copy only is created, the subsequent...

    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 8, 2011 at 9:24 am

    #1378648

  • RE: truncate first or drop index firast, which is faster?

    sturner (9/8/2011)

    Ninja's_RGR'us (9/8/2011)

    I would personnally disable the indexes. That way you don't have to bother about keeping the packages in sync with the index mods for tuning or whatknot.

    Only...

    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 8, 2011 at 9:22 am

    #1378643

  • RE: Differential and log backups fail after full backup

    Implied by what a copy_only backup is.

    A copy_only full backup doesn't set the differential base and can't be a base for log backups. Hence if that's the only 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

    September 8, 2011 at 9:21 am

    #1378637

  • RE: Strange SQL Server Evaluation of 0 (bit) = '' (Empty string) or even non empty string

    andy.fensham (9/8/2011)

    but 0 should not be equal to a string with 10 spaces, so I find the implicit conversion not very consistent.

    As far as SQL is concerned, a string with...

    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 8, 2011 at 9:18 am

    #1378629

Viewing 15 posts - 23,641 through 23,655 (of 49,552 total)