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...
Author: Alexander Chigrik
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 useful SQL Server 2014 trace flags
Some useful SQL Server 2014 trace flags Trace flags are used to temporarily set specific server characteristics or to switch off a particular behavior. You can set trace flags by using the DBCC TRACEON command or by using the -T option with the sqlservr command-line executable. There are 2 types of trace flags in SQL Server 2014: – global trace...
Some useful SQL Server 2014 trace flags
Some useful SQL Server 2014 trace flags Trace flags are used to temporarily set specific server characteristics or to switch off a particular behavior. You can set trace flags by using the DBCC TRACEON command or by using the -T option with the sqlservr command-line executable. There are 2 types of trace flags in SQL Server 2014: – global trace […]
Some tips to use System Monitor with SQL Server 2014
Some tips to use System Monitor with SQL Server 2014 System Monitor works on Windows operating systems and can be used to monitor an instance of SQL Server 2014. The difference between SQL Server Profiler and System Monitor is that SQL Server Profiler monitors Database Engine events, whereas System Monitor monitors resource usage associated with server processes. Ensure that SQL...
Some tips to use System Monitor with SQL Server 2014
Some tips to use System Monitor with SQL Server 2014 System Monitor works on Windows operating systems and can be used to monitor an instance of SQL Server 2014. The difference between SQL Server Profiler and System Monitor is that SQL Server Profiler monitors Database Engine events, whereas System Monitor monitors resource usage associated with server processes. Ensure that SQL […]
SQL Server 2014 Transact-SQL Optimization Tips (Part 2)
SQL Server 2014 Transact-SQL Optimization Tips (Part 2) Try to restrict the queries result set by using the WHERE clause. This can results in good performance benefits, because SQL Server will return to client only particular rows, not all rows from the table(s). This can reduce network traffic and boost the overall performance of the query. Consider using the CONTAINS...
SQL Server 2014 Transact-SQL Optimization Tips (Part 2)
SQL Server 2014 Transact-SQL Optimization Tips (Part 2) Try to restrict the queries result set by using the WHERE clause. This can results in good performance benefits, because SQL Server will return to client only particular rows, not all rows from the table(s). This can reduce network traffic and boost the overall performance of the query. Consider using the CONTAINS […]
SQL Server 2014 Transact-SQL Optimization Tips (Part 1)
SQL Server 2014 Transact-SQL Optimization Tips (Part 1) Use views and stored procedures instead of heavy-duty queries. This can reduce network traffic, because your client will send to server only stored procedure or view name (perhaps with some parameters) instead of large heavy-duty queries text. This can be used to facilitate permission management also, because you can restrict user access...
SQL Server 2014 Transact-SQL Optimization Tips (Part 1)
SQL Server 2014 Transact-SQL Optimization Tips (Part 1) Use views and stored procedures instead of heavy-duty queries. This can reduce network traffic, because your client will send to server only stored procedure or view name (perhaps with some parameters) instead of large heavy-duty queries text. This can be used to facilitate permission management also, because you can restrict user access […]