Forum Replies Created

Viewing 10 posts - 31 through 40 (of 40 total)

  • RE: Test restore of backups...

    What are some of the ways that you guys go about test-restoring your backups?

    Is it automated or is it all manual? If it is automated what tools or scripts...

  • RE: Removing possible bad Indexes

    Thanks for all of the input everybody. Disabled the indexes and haven't seen any issues.

  • RE: Removing possible bad Indexes

    Steve Jones - SSC Editor (7/9/2012)


    I'd concur with Alan on the disabling them. Easier to put them back if you have issues.

    Would it be better to simply right click ->...

  • RE: Removing possible bad Indexes

    XMLSQLNinja (7/9/2012)


    Determining the performance impact of removing these unused indexes is important; understanding the impact of leaving them there is also important. In the past 14 years I cannot recall...

  • RE: Removing possible bad Indexes

    Joie Andrew (7/5/2012)


    Is it a third-party app database or an in-house app that you have reach-back to the devs?

    I'm going to get with the "owner" of the database and...

  • RE: Please suggest one best book for learning total concepts of SQL DBA...

    Another book I recommend is SQL Server 2008 Administration in Action by Rod Colledge. It has a lot of practical techniques, best practices, and even a recommended work flow. It...

  • RE: Please suggest one best book for learning total concepts of SQL DBA...

    jr.sqldba (6/28/2012)


    Hello,

    Please suggest me one best book for learning total concepts of sql server administration.

    Thank you,

    sri.

    There are probably hundreds of books out there for this. You've just got to find...

  • RE: Test restore of backups...

    Thanks everyone - all good advice.

    One of the issues we face is that we only have a 1Gbit network connection for our backup servers. It can take quite a...

  • RE: Test restore of backups...

    Lynn - thanks for the input. I'm going to use this quote going forward: "backups are worthless, restores are priceless."

    Grant - Awesome articles and examples. Gives me some ammunition...

  • RE: inserting Output of sys.dm_os_performance_counters Script into a table...

    This was much easier than I first anticipated....

    Updated the script below to output to table (search YOUR.TABLE.NAME.HERE to edit).

    This is a pretty handy script nonetheless....

    --http://www.databasejournal.com/features/mssql/article.php/3914366/Collecting-Performance-Metrics-Using-SQL-Server-DMV.htm

    --Script by Gregory A. Larsen

    DECLARE...

Viewing 10 posts - 31 through 40 (of 40 total)