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)
6,370 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,324 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,604 reads
Blogs
How to get data in a DataFrame via .NET for Apache Spark
By Ed Elliott
When I first started working with Apache Spark, one of the things I struggled...
The End of PASS
By Andy Warren
I think our profession was the better for having a professional association, even if...
Platforms for Events
By Andy Warren
in my last post I wrote about thinking of the tools as being a...
Forums
Nested loop/HashJoin and left/right/full join
1. What is the difference among nested loop?hash join and merge join? 2. what...
SSMS & Excel - Copy Paste - DateTime Columns
Dear Group: I am not sure if this is a T-SQL / SSMS issue,...
Linked Server Insert error
Hello i have linked server one server in cloud one is local from local...
Ask SSC