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 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 views0 comments
    Adam Thurgar
    • Sep 20, 2017
    • 1 min

    Migrating SSIS packages to AWS

    We are currently migrating a large amount of SSIS packages (SQL Server 2008R2) to SQL Server 2016 at AWS. It has been a learning exercise...

    32 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 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 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 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
    Repost - originally posted 14-06-2012
    • Aug 27, 2017
    • 1 min

    Local and Global Temporary Tables

    Whilst reviewing some code recently I saw the creation of a global temporary table (##). There was actually no need to create a global t...

    3 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 22-05-2012
    • Aug 20, 2017
    • 1 min

    sp_helpindex stored procedure improvements

    When SQL Server introduced the concept of included columns in indexes in SQL Server 2005, they didn't really provide any way to get infor...

    12 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 20-05-2012
    • Aug 17, 2017
    • 1 min

    Changing the sa login for improved security

    This is just a simple tip to improve the security of your SQL Server installation. If you can, you should try and rename the sa login. It...

    4 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
    Repost - originally posted 28-11-2012
    • Aug 12, 2017
    • 1 min

    SQL Server configuration - default file locations

    How do you make sure that any user database created is created on the disks that you have set aside for the data, transaction log and bac...

    3 views0 comments
    Repost - originally posted 04-12-2012
    • Aug 11, 2017
    • 1 min

    SQL Server configuration - default fill factor

    The setting of the correct index fill factor is a constant source of debate amongst DBAs. There is a lot of information that you need to ...

    3 views0 comments