Troubleshooting SQL Server 2017 Columnstore Indexes If you have problems with SQL Server 2017 columnstore indexes, review this troubleshooting checklist to find potential solutions. 1. You can get the error 980 when you try to load SQL Server 2017 database. This is the error message text: “SQL Server cannot load database ‘%.*ls’ because it contains a columnstore index.” This error...
Tag: BULK insert
Tips for using bulk copy in SQL Server 2017
Tips for using bulk copy in SQL Server 2017 Consider using BULK INSERT to insert data from files stored in Azure Blob storage. Beginning with SQL Server 2017 BULK INSERT command enable access data directly from a file specified as CSV format, and from files stored in Azure Blob storage through the new BLOB_STORAGE option of EXTERNAL DATA SOURCE. Use...
Troubleshooting SQL Server 2016 Bulk Copy Problems
Troubleshooting SQL Server 2016 Bulk Copy Problems If you have problems with SQL Server 2016 bulk copy, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2016 service pack. Because many SQL Server 2016 bulk copy bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the...
Tips for using SQL Server 2016 Integration Services (Part 3)
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...
Tips for using SQL Server 2016 Integration Services (Part 2)
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...
Tips for using SQL Server 2016 Integration Services (Part 1)
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...
Some tips for using bulk copy in SQL Server 2016
Some tips for using bulk copy in SQL Server 2016 Consider using minimally logged bulk copy whenever possible. The minimally logged bulk copy is much faster than other bulk copy methods, but to use it you must provide all the following conditions: 1. The database option ‘select into/bulkcopy’ is set to true (by the way, using this option causes the […]
Troubleshooting SQL Server 2014 Bulk Copy Problems
Troubleshooting SQL Server 2014 Bulk Copy Problems If you have problems with SQL Server 2014 bulk copy, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2014 service pack. Because many SQL Server 2014 bulk copy bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the […]
Tips for using Integration Services in SQL Server 2014 (Part 2)
Tips for using Integration Services in SQL Server 2014 (Part 2) Use the bcp utility instead of Integration Services when you need to export data from the SQL Server table into a text file. The bcp utility is much faster than SSIS, so try to use it whenever possible. If you need to sort data or identify similar data rows,...
Tips for using Integration Services in SQL Server 2014 (Part 1)
Tips for using Integration Services in SQL Server 2014 (Part 1) Try to avoid SSIS lookups. Because SSIS lookups slow down performance, try to use the Transact-SQL statements to perform the same functions. If you need to combine data rows from multiple upstream data flow components, you can use the Union All, Merge, and Merge Join transformations. These transformations make...