Force installation of 64-bit ACE OLE DB provider
Anyone working with SSIS and Excel probably had the following issue: you are creating an SSIS package using an Excel...
2013-04-25 (first published: 2013-04-23)
12,714 reads
Anyone working with SSIS and Excel probably had the following issue: you are creating an SSIS package using an Excel...
2013-04-25 (first published: 2013-04-23)
12,714 reads
Last week I took the final exam to acquire the MCSE – Business Intelligence certification. This blog post describes my preparation...
2013-04-04
18,452 reads
Some time ago Data Explorer, an add-in for Excel 2010 or 2013, was released in Public Preview. In short, it...
2013-03-20
829 reads
When it comes to importing data from an Excel sheet with SSIS, Excel has quite a reputation. And not a...
2012-11-27
1,607 reads
By Steve Jones
flichtish – adj. nervously aware how much of your self-image is based on untested...
In a previous post we went through how to use Docker Build Cloud to...
By Steve Jones
We’re taking the roadshow across the water. Hope the plane makes it. The Redgate...
Just came across something weird. Was wondering if anyone else has ever seen this....
My database was in suspect mode, and when I checked using DBCC CHECKDB, it...
Comments posted to this topic are about the item Creating Statistics on XML
I have a table in SQL Server 2022 that is an XML data type. I have an index on this column and want to create statistics using CREATE STATISTICS for some of the data in the column. What should I do?
See possible answers