ST

 

Excellence in SQL Server

  • HOME

  • EXPERTISE

  • BLOGS

  • CONTACT US

  • Blog

  • More

    • All Posts
    • AlwaysOn Availability Groups
    • Trace Flags
    • Alerts
    • Performance
    • Best Practice
    • Security
    • Maintenance
    • Problems and Issues
    • Configuration
    • SQL Server 2016
    • Tips and Tricks
    Search
    Repost - originally posted 27-07-2012
    • Sep 17, 2017
    • 1 min

    Review missing index findings before you implement

    There are a number of queries widely available that will look at the DMVs and tell you what indexes you may be missing. This is a great h...

    3 views0 comments
    Repost - originally posted 19-07-2012
    • Sep 12, 2017
    • 1 min

    Autoclose and autoshrink - set them to off

    By running a simple check of your database settings (use helpdb or query sys.databases) you may find databases that are set to autoclose ...

    3 views0 comments
    Repost - originally posted 05-07-2012
    • Sep 6, 2017
    • 1 min

    Insert query performance improvement

    I was asked the other day was there any way to improve the performance of a large number of rows being inserted. My immediate thought was...

    2 views0 comments
    Repost - originally posted 29-06-2012
    • Sep 4, 2017
    • 1 min

    SQL Server Clustering

    Recently we were asked to build a SQL Server cluster. My initial thought was to use some other technology to provide high availability li...

    5 views0 comments
    Adam Thurgar
    • Aug 18, 2017
    • 1 min

    Index your updates

    We are currently working on a project to do a major data update on a manufacturing database to update client and product codes in prepara...

    3 views0 comments
    Repost - originally posted 24-10-2012
    • Jul 27, 2017
    • 1 min

    Implicit conversions and poor performance

    Whilst debugging a slow query recently and went through the usual suspects. There were indexes on join columns, all the table joins were ...

    7 views0 comments
    Adam Thurgar
    • Jul 26, 2017
    • 1 min

    Clustered index column in non-clustered indexes

    Whilst recently reviewing performance issues on a large legal system, I noticed that every non-clustered index, explicitly included the c...

    4 views0 comments