Author: Alexander Chigrik

SQL Server

Some useful undocumented SQL Server 2016 extended stored procedures

Some useful undocumented SQL Server 2016 extended stored procedures In this article, you can find the description of some useful undocumented SQL Server 2016 extended stored procedures. xp_enum_oledb_providers This extended stored procedure can be used to get the list of all available OLE DB providers. It returns Provider Name, Parse Name and Provider Description. Syntax: EXECUTE xp_enum_oledb_providers To get a […]

SQL Server

Troubleshooting SQL Server 2016 backup/restore problems

Troubleshooting SQL Server 2016 backup/restore problems If you have problems with SQL Server 2016 backup/restore, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2016 service pack. Because many SQL Server 2016 backup/restore bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the time this article […]

SQL Server

Troubleshooting SQL Server 2016 Reporting Services

Troubleshooting SQL Server 2016 Reporting Services If you have problems with SQL Server 2016 Reporting Services (SSRS 2016), review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2016 service pack. Because many SQL Server 2016 Reporting Services bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At […]

SQL Server

Troubleshooting SQL Server 2016 Integration Services

Troubleshooting SQL Server 2016 Integration Services If you have problems with SQL Server 2016 Integration Services (SSIS), review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2016 service pack. Because many SQL Server 2016 Integration Services bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the […]

SQL Server

Tips for using indexes in SQL Server 2016 (Part 1)

Tips for using indexes in SQL Server 2016 (Part 1) Consider creating the columnstore indexes on the memory-optimized tables. Beginning with SQL Server 2016, you can create a memory-optimized table with a columnstore index. You can use the ALTER TABLE ADD INDEX statement to add the columnstore index after the memory-optimized table is created. Create a clustered index for each […]

SQL Server

Some useful SQL Server 2016 trace flags

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 […]