Forum Replies Created

Viewing 15 posts - 15,601 through 15,615 (of 49,552 total)

  • RE: !!! Database server slowing down

    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

    November 19, 2012 at 2:10 am

    #1560211

  • RE: size of LOB data 41GB smaller after BACKUP/RESTORE

    sqlnyc (11/18/2012)

    DBCC UPDATEUSAGE (<dbname>)

    WITH NO_INFOMSGS, COUNT_ROWS

    That.

    You probably had some page usage errors within the DB (incorrect metadata as to how full pages were). Very common on SQL 2000, less common...

    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 19, 2012 at 1:57 am

    #1560203

  • RE: DOT.NET Data Reader

    jrichards54 (11/18/2012)

    Excuse me Sir, I am a little bit confused about where to post this. I thought that you were telling me to post this in a different forum

    Yes,...

    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 18, 2012 at 2:22 pm

    #1560129

  • RE: DOT.NET Data Reader

    Please don't post multiple threads for the same question.

    http://www.sqlservercentral.com/Forums/Topic1386047-149-1.aspx

    As I suggested in the other thread you posted, you're likely to be better off posting this on a .Net forum,...

    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 18, 2012 at 1:21 pm

    #1560122

  • RE: New DBA job, done some digging on Database and have some concerns!

    Joie Andrew (11/18/2012)

    you may have to go back to a database that is quite old and restore all the transaction log backups in order to fix the corruption and ensure...

    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 18, 2012 at 12:21 pm

    #1560115

  • RE: size of LOB data 41GB smaller after BACKUP/RESTORE

    Any index rebuilds or reorganise? Is autoshrink enabled?

    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 18, 2012 at 12:20 pm

    #1560114

  • RE: SQL Server 2005 Data Reader

    I'd suggest you post this question on a .Net forum (or maybe somewhere like StackOverflow). The functioning and internals of the SQLDataReader is all .Net, nothing within SQL Server itself,...

    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 18, 2012 at 12:19 pm

    #1560113

  • RE: Find out the size of database tables, row count, data size, index growth

    Not offhand, no. It's not hard though, most of the data you want is in sys.dm_db_partition_stats, you just need to join to the others to get the names.

    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 18, 2012 at 10:41 am

    #1560099

  • RE: New DBA job, done some digging on Database and have some concerns!

    bugg (11/18/2012)

    What performance impact will it have on a production DB? The DB is up 24/7 with users connected at all times.

    Somewhere between none and horrid. It's an IO...

    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 18, 2012 at 10:06 am

    #1560096

  • RE: Find out the size of database tables, row count, data size, index growth

    sys.databases

    sys.tables

    sys.indexes

    sys.dm_db_partition_stats

    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 18, 2012 at 10:04 am

    #1560095

  • RE: SQL Server 2005 Data Reader

    Do you mean the .Net SQLDataReader class?

    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 18, 2012 at 10:02 am

    #1560092

  • RE: backup/restore process

    Don't append backups to one file. Backups should ideally each to their own file, preferably time-stamped (DatabaseName20121115211501.trn)

    To restore to a point in time, you need a full backup taken before...

    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 18, 2012 at 10:01 am

    #1560091

  • RE: rebuild index worsens query performance

    jgenovese (11/17/2012)

    my apologies for the runaround on the query plan -- I thought sys.dm_exec_text_query_plan yielded an actual, apparently that's not the case

    Definition of an 'actual plan' is a plan 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

    November 17, 2012 at 3:13 pm

    #1560062

  • RE: Tempdb: per Instance not per Database?

    Per instance

    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 17, 2012 at 12:28 pm

    #1560041

  • RE: Stop sql serive also stops another service

    Well, did you go through the registry to create the dependency on the current server? I highly doubt 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

    November 17, 2012 at 12:16 pm

    #1560038

Viewing 15 posts - 15,601 through 15,615 (of 49,552 total)