Monthly Archives: July 2018

RECOMPLE behavior the difference between OPTION ( RECOMPILE ) AND WITH RECOMPILE

By | July 17, 2018

An interesting problem was posted on #SQLHelp the other day about using the QueryHint OPTION(RECOMPILE). If you are not sure about how recompile works here is a quick primer. Stored procedures can be expensive to run so SQL Server database engine takes a moment when running the procedure the first time to come up with… Read More »

Smart Log backups SQL Server 2017

By | July 3, 2018

Smart log backups is a feature introduced in SQL 2017 to allow DBAs to manage the transaction log growth better. Before we go into details it might be better to understand what problem it was trying to solve. In any typical production workload we often have uneven usage on the database system, often the majority… Read More »

Changing Default port number for SQL on Windows/Linux Install

By | July 2, 2018

Changing the default port number of a SQL installation is one of the most basic post install steps performed. It is mainly used to make intrusion more difficult by preventing users from taking advantage of the default settings which are known in the public domain. SQL Server when install as a default instance uses port… Read More »