Tips for using SQL Server 2017 configuration options (Part 2) Consider changing the ‘fill factor’ option to the appropriate value. The ‘fill factor’ option specifies how full SQL Server 2017 will make each index page. When there is no free space to insert new row on the index page, SQL Server will create new index page and transfer some rows...
Tag: sp_configure
Tips for using SQL Server 2017 configuration options (Part 1)
Tips for using SQL Server 2017 configuration options (Part 1) In this article, you can find the description of some useful SQL Server 2017 configuration options with the examples how to make it by using the sp_configure system stored procedure. Note. Because setting up some SQL Server 2017 configuration options can degrade performance you should change these options very carefully...
Tips for using SQL Server 2016 configuration options
Tips for using SQL Server 2016 configuration options In this article, you can find the description of some useful SQL Server 2016 configuration options with the examples how to make it by using the sp_configure system stored procedure. Note. Because setting up some SQL Server 2016 configuration options can degrade performance you should change these options very carefully and continue...
Troubleshooting SQL Server 2014 System Stored Procedures
Troubleshooting SQL Server 2014 System Stored Procedures If you have problems with SQL Server 2014 system stored procedures, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2014 service pack. Because many system stored procedures bugs were fixed in SQL Server 2014 service packs, you should install the latest SQL Server service pack. At the […]
Some tips for using SQL Server 2014 configuration options
Some tips for using SQL Server 2014 configuration options SQL Server 2014 configuration options may be separated to two categories: – Options that take effect immediately after setting the option and issuing the RECONFIGURE. – Options that take effect only after restarting the instance of SQL Server. In this article, you can find the description of some useful SQL Server...
Some tips for using SQL Server 2014 configuration options
Some tips for using SQL Server 2014 configuration options SQL Server 2014 configuration options may be separated to two categories: – Options that take effect immediately after setting the option and issuing the RECONFIGURE. – Options that take effect only after restarting the instance of SQL Server. In this article, you can find the description of some useful SQL Server […]
Tips for using SQL Server 2012 configuration options
Tips for using SQL Server 2012 configuration options One of the ways to optimize SQL Server 2012 performance is setting the appropriate server configuration options. You can set these options by using the SQL Server Management Studio or the sp_configure system stored procedure. SQL Server 2012 configuration options may be separated to two categories: – Options that take effect immediately...