Converting Inches to Centimeters - Long Hand
Today I had to write a little function that takes the long had version of a fraction, say 8 3/4 and convert it a proper number (float) and then...
2013-02-26
17 reads
Josef Richberg
Converting Inches to Centimeters - Long Hand
Today I had to write a little function that takes the long had version of a fraction, say 8 3/4 and convert it a proper number (float) and then...
2013-02-26
16 reads
Working with Excel Destinations in SSIS - 0xC0202025, 0x80040E21
Working with Excel in SSIS is not fun and something I whole-heartedly discourage. With that said, I had a not...
2012-12-12
1,522 reads
Existence Check Deconstructed -- SSIS Lookup Transformation
There are countless ways to mix and match components in SSIS to simulate what SQL Server does in a query....
2012-11-10
1,043 reads
Existence Check Deconstructed -- SSIS Lookup Transformation
There are countless ways to mix and match components in SSIS to simulate
what SQL Server does in a query. Here I am going to show you how to...
2012-11-10
65 reads
Existence Check Deconstructed -- SSIS Lookup Transformation
There are countless ways to mix and match components in SSIS to simulate what SQL Server does in a query. Here I am going to show you how to...
2012-11-10
19 reads
SSIS Data Flow Tuning
During my SSWUG webcast I was asked to give some examples on how to tune the DefaultBufferMaxRows and DefaultBufferSize, so...
2012-04-27
2,825 reads
SSIS Data Flow Tuning
During my SSWUG webcast I was asked to give some examples on how to tune
the DefaultBufferMaxRows and DefaultBufferSize, so here goes.
When a source is pulling in data, it places them into...
2012-04-27
223 reads
SSIS Data Flow Tuning
During my SSWUG webcast I was asked to give some examples on how to tune the DefaultBufferMaxRows and DefaultBufferSize, so here goes.
When a source is pulling in data, it...
2012-04-27
21 reads
SSWUG Expo..I'm up!
I am proud to say that one of the webcasts I taped last year for SSWUG is part of the...
2012-04-26
334 reads
Blogs
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
Forums
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers