Import multiple text files with the same csv format using T-SQL

Recently needed to import 4,000 plus text files into SQL. This was an easy job as: All files were in the same directory All files had the same csv structure. All files had the same file name except for a changing date suffix (eg: 20140131.txt) For the following code to work, you need to have previously set up a date table (tDate) and a … [Continue reading...]

Boost SQL performance with Date (Calendar) tables

A date (or calendar) table is a SQL table containing a variety of date-related parameters. By joining to this table, one can rapidly access the pre-calculated values, thus significantly simplifying & speeding up your queries. Using 18 December 2013 as an example, the following parameters would be available: Parameter Value Date … [Continue reading...]