SSIS OLEDB Command and procedure output params
While designing a package last week with our consultant, Latha Chathri (
twitter), I came across a need to call a stored procedure drom within a
Data Flow Task. I have...
2011-06-30
42 reads
Josef Richberg
SSIS OLEDB Command and procedure output params
While designing a package last week with our consultant, Latha Chathri (twitter), I came across a need to call a stored procedure drom within a Data Flow Task. I...
2011-06-30
12 reads
Statistics IO parser in Ruby & Python
Here I am working on tuning a rather large stored procedure; old school. I have statistics IO and showplan turned on....
2011-06-10
667 reads
Statistics IO parser in Ruby & Python
Here I am working on tuning a rather large stored procedure; old school. I
have statistics IO and showplan turned on. I work through the obvious
missing indexes and improper joins and now...
2011-06-10
37 reads
Statistics IO parser in Ruby & Python
Here I am working on tuning a rather large stored procedure; old school. I have statistics IO and showplan turned on. I work through the obvious missing indexes and improper...
2011-06-10
7 reads
Improved partition loading
We have a table that contains just over 1.7 billion records and requires a daily feeding of around 9 million....
2011-06-06
515 reads
Improved partition loading
We have a table that contains just over 1.7 billion records and requires a
daily feeding of around 9 million. It is split into 10, roughly equal,
partitions. I...
2011-06-06
13 reads
Improved partition loading
We have a table that contains just over 1.7 billion records and requires a daily feeding of around 9 million. It is split into 10, roughly equal, partitions. I...
2011-06-06
4 reads
SQL Lunch #48 Advanced SSIS Tips & Tricks
I had the privilege of giving a SQL Lunch presentation today. The slide deck for that can be found here:...
2011-01-30
1,888 reads
SQL Lunch #48 Advanced SSIS Tips & Tricks
I had the privilege of giving a SQL Lunch presentation today. The slide deck for that can be found here: SSIS Tips & Tricks deck. The recording can be...
2011-01-30
12 reads
Blogs
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
T-SQL Tuesday #192: What career risks have you taken?
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
T-SQL Tuesday #196: Taking Risks
By Steve Jones
This month we have a new host, James Serra. I’ve been trying to find...
Forums
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Going Native with Fabric Spark Pools: The Fabric Modern Data Platform
Comments posted to this topic are about the item Going Native with Fabric Spark...
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers