Author: Alexander Chigrik

Pro Members SQL Server Standard Members

Some useful SQL Server 2016 trace flags

by

Some useful SQL Server 2016 trace flags Trace flags are used to temporarily set specific server characteristics or to switch off a particular behavior. There are 3 types of trace flags in SQL Server 2016: query trace flags global trace flags session trace flags Query trace flags are active for the context of a specific query. A global trace flag...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Tips to use System Monitor with SQL Server 2016

by

Tips to use System Monitor with SQL Server 2016 System Monitor works on Windows operating systems and can be used to monitor an instance of SQL Server 2016. 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. To start System Monitor...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Tips for using SQL Server 2016 configuration options

by

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...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

SQL Server 2016 Transact-SQL Optimization Tips (Part 2)

by

SQL Server 2016 Transact-SQL Optimization Tips (Part 2) Try to restrict the queries result set by returning only the particular columns from the table, not all table’s columns. This can results in good performance benefits, because SQL Server will return to client only particular columns, not all table’s columns. This can reduce network traffic and boost the overall performance of...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

SQL Server 2016 Transact-SQL Optimization Tips (Part 1)

by

SQL Server 2016 Transact-SQL Optimization Tips (Part 1) Consider using a new query hint NO_PERFORMANCE_SPOOL. This hint was first introduced in SQL Server 2016 and can prevent a spool operator from being added to query plans. This can improve performance when many concurrent queries are running with spool operations. Try to restrict the queries result set by using the WHERE...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

How to identify missing SQL Server indexes

by

How to identify missing SQL Server indexes Microsoft SQL Server supports many useful stored procedures, functions and operators. Some actions you can perform without using these features, but usually using them provides more easy and effective way to accomplish the same goal. For example, in SQL Server 2005, Microsoft introduced Dynamic Management Views (DMVs). Of course the DMVs are supported...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Tips for using SQL Server 2016 Integration Services (Part 3)

by

Tips for using SQL Server 2016 Integration Services (Part 3) Consider encrypting Integration Services packages. SQL Server 2016 Integration Services packages can be encrypted with various levels of encryption. By encrypting packages, you can protect sensitive data. If you need to modify column values, you can use the Data Conversion and Derived Column transformations. These transformations were first added in...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Tips for using SQL Server 2016 Integration Services (Part 2)

by

Tips for using SQL Server 2016 Integration Services (Part 2) Consider disabling constraints during the data load operation. To disable constraints during the data load operation, you can turn off the “Check constraints” option in the OLE DB Destination Editor. Try to avoid using the Aggregate and Sort transformations. Because using these transformations may be very resource expensive, you should...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Tips for using SQL Server 2016 Integration Services (Part 1)

by

Tips for using SQL Server 2016 Integration Services (Part 1) Integration Services (SSIS) were first introduced in SQL Server 2005 and replace the Data Transformation Services (DTS). By using the SSIS you can load data into or out from SQL Server relational databases or data warehousing. In this article, you can find some tips to boost the SQL Server 2016...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Some tips to work with SQL Server 2016 alerts

by

Some tips to work with SQL Server 2016 alerts SQL Server 2016 writes the events into the Windows Application log. SQL Server Agent checks the Windows application log for SQL Server events. When an event occurs, the SQL Server Agent checks if the appropriate alert exists and if so perform the defined response. Alerts can be used to execute a...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
1 … 15 16 17 18 19 … 42