Tag Archives: Tips & Tricks

How to ignore security settings in SQL Server Database Project (SSDT)

In SSDT project, you could create everything you want and keep them identical with target database. However, security might be an exception, few reason you might want to manage security out side of SSDT project: You need to create a … Continue reading

Posted in SSDT, Uncategorized | Tagged , | Leave a comment

Tips: Avoid single-use cached plan with ‘optimize for ad hoc workloads’ in the SQL Server 2008 or later

In SQL Server 2008, there is a new server configuration option introduced, called ‘optimize for ad hoc workloads’. This option can improve the efficiency of the plan cache for single use ad-hoc queries (or called dynamic SQL). When this option … Continue reading

Posted in Database Engine, Script Library, Tips & Tricks | Tagged , , | 1 Comment