Importing Files in Parallel with SSIS
Run multiple instances of your package in parallel so that each instance processes a portion of the total number of files
2019-08-23 (first published: 2017-11-07)
7,567 reads
Paulo de Jesus
A Simple Introduction to Dynamic SQL
Dynamic SQL is essentially normal SQL written in such a way that you end up with a “customised” SQL script at run-time.
2018-02-12
3,883 reads
Setting up R in SQL 2016 – Avoiding Pitfalls
Setting up R in SQL 2016 proved to be trickier than expected, but here is how to avoid the frustrations.
2017-06-15
1,991 reads
Blogs
Opening the SQL Prompt Command Palette
By Steve Jones
A few years ago SQL Prompt added a command palette to let you search...
Common Mistakes in SQL Server – Part 2
The Identity property creates an incremental value for the specified column automatically, which is...
Forums
SQL Migration - Identifying Connections - Best approach
I have one SQL Database server which is old version and planning to migrate...
Restore With Standby; A Review and A Lesson Learned
Comments posted to this topic are about the item Restore With Standby; A Review...
Are You Worried About AI?
Comments posted to this topic are about the item Are You Worried About AI?
Ask SSC