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 05-08-2012
    • Sep 28, 2017
    • 1 min

    Standardise database sizes and automation

    The default setting for the initial sizing of data and log files (and their autogrowth) is not adequate. I like to make sure that we set ...

    2 viewsWrite a comment
    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 viewsWrite a comment
    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 viewsWrite a comment
    Repost - originally posted 13-07-2012
    • Sep 8, 2017
    • 1 min

    Report name variable in Sharepoint

    Whilst deploying some reports to a new Sharepoint installation I noticed that the global ReportName variable (Globals!ReportName) include...

    3 viewsWrite a comment