Forum Replies Created

Viewing 15 posts - 44,251 through 44,265 (of 49,552 total)

  • RE: Performance Implications of Database Snapshots

    Dunno. Probably.

    I've seen people suggest snapshots for month-end reporting with the intention of keeping the snapshots in place for a year.

    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 23, 2008 at 10:56 am

    #875899

  • RE: DMV question

    Jack Corbett (9/23/2008)

    I was wondering the same about the clustered index or the heap (some people still don't always have a clustered index). That's why I mentioned that it...

    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 23, 2008 at 10:24 am

    #875878

  • RE: Issue with Logical Reads

    Doesn't mean that the index is completely appropriate. The DTA sometimes gets it wrong.

    Can you please post table structure, index defs, query and exec plan please. (exec plan saved 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

    September 23, 2008 at 10:06 am

    #875861

  • RE: Recovering space by using Shrink Database/Lof Files command on SQLServer 2000.

    Also have a read through this for a quick overview of how recovery models affect the tran log:

    http://sqlinthewild.co.za/index.php/2008/07/23/recovery-model-and-transaction-logs/

    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 23, 2008 at 9:56 am

    #875847

  • RE: DMV question

    You can, however if a column isn't indexed a change to it won't reflect in that DMV. I don't know if, for the purposes of that DMV, all the columns...

    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 23, 2008 at 9:53 am

    #875842

  • RE: backup with truncate_only problems

    AlexSQLForums (9/23/2008)

    I had a truncate log step right after full backup.

    You need the full backup after the truncate to restart the broken log chain.

    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 23, 2008 at 9:51 am

    #875837

  • RE: Performance Implications of Database Snapshots

    I don't think it will make any difference. The extra time comes from writing the original version of the modified pages into the snapshot files, not from searching through tables...

    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 23, 2008 at 9:37 am

    #875822

  • RE: Index scans and nested queries.

    Can you post the exec plan please? (saved as a .sqlplan file, zipped and attached)

    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 23, 2008 at 9:30 am

    #875815

  • RE: Point in time recovery

    What was the error it was giving?

    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 23, 2008 at 9:29 am

    #875814

  • RE: DMV question

    There's no DMV that tracks that. You can run profiler or you can put a trigger on to the tables to count the changes made.

    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 23, 2008 at 9:25 am

    #875803

  • RE: backup with truncate_only problems

    As soon as you truncate the log you've broken the log chain. Any log backups taken after that point are useless and the log records will be automatically discarded (when...

    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 23, 2008 at 9:20 am

    #875798

  • RE: Execution Plan question

    Possibly that it's running as a parallel operation. If you could attach a pic of said operator, I can tell you for sure.

    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 23, 2008 at 9:14 am

    #875791

  • RE: Another Backup scenario

    Ahmad Osama (9/23/2008)

    Cath Trimble (9/23/2008)

    If a Full backup has never been taken, there is no way to recover the table - any backup taken after the table was deleted would...

    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 23, 2008 at 9:03 am

    #875772

  • RE: Moving system database's log file on a cluster

    You don't need to stop SQL and the agent after doing the alter (not for the user databases). Just take the database offline after doing the alter database, move 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 23, 2008 at 9:01 am

    #875767

  • RE: Update Stats for SQL Server 2005

    Most of that you can get by using sys.indexes instead of sysindexes. The row count you can get from sys.dm_db_index_physical_stats.

    The one thing you won't be able using the DMVs 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 23, 2008 at 8:55 am

    #875760

Viewing 15 posts - 44,251 through 44,265 (of 49,552 total)