ST

 

Excellence in SQL Server

  • HOME

  • EXPERTISE

  • BLOGS

  • CONTACT US

  • Blog

  • More

    • All Posts
    • AlwaysOn Availability Groups
    • Trace Flags
    • Alerts
    • Performance
    • Best Practice
    • Maintenance
    • Security
    • Problems and Issues
    • Configuration
    • SQL Server 2016
    • Tips and Tricks
    Search
    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 26-06-2012
    • Sep 1, 2017
    • 1 min

    Hypothetical indexes

    We had a query recently about a database that had a lot of objects starting with the name _dta_. We explained that these where hypothetic...

    2 views0 comments
    Adam Thurgar
    • Aug 30, 2017
    • 1 min

    Docker update - Linux good

    After touching base with a few contacts at Microsoft, I tried a number of suggestions to get the Windows container working with SQL Serve...

    3 views0 comments
    Repost - originally posted 07-06-2012
    • Aug 24, 2017
    • 2 min

    How one small change caused the CPU to go crazy

    Finding the cause of very high CPU usage on your SQL Server may not be as easy as running scripts against a few DMV's, looking at perfmon...

    5 views0 comments
    Repost - originally posted 1-06-2012
    • Aug 22, 2017
    • 1 min

    Poor object naming

    The following is an example of a poorly named table from a major backup software vendor. This caused failures with the regular maintenan...

    3 views0 comments
    Repost - originally posted 21-06-2012
    • Aug 14, 2017
    • 1 min

    Full recovery = transaction log backups

    A common occurrence in reviewing SQL Server implementations is finding very large databases that have log file sizes greater than the siz...

    5 views0 comments
    Repost - originally posted 29-05-2012
    • Aug 13, 2017
    • 1 min

    Model database recovery setting

    We see a lot of databases in full recovery that don't need to be. Why? Because the default for the model database (used as the template f...

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

    SQL Server 2016 Temporal tables

    Whilst trying to create a temporal table (system versioned table) on SQL Server 2016, I kept getting a syntax error on the SET (SYSTEM_VE...

    4 views0 comments
    Adam Thurgar
    • Jul 29, 2017
    • 1 min

    Linked Servers, SSIS and user name formats

    I have spent most of the past 5 to 6 years upgrading SQL Servers. Upgrading from SQL Server 2000 (and prior), 2005, 2008 and 2008R2 to SQ...

    4 views0 comments
    Adam Thurgar
    • Jul 23, 2017
    • 1 min

    The data file (mdf) that wouldn't grow

    Recently we had an issue where a database was unable to grow the mdf file. This was causing availability issues as no new inserts were ab...

    5 views0 comments