Simple Series : SSIS Conditional Split
Conditional Split is a very powerful component, enabling you to send records in different directions or exclude them from the downstream...
2010-03-26
918 reads
Josef Richberg
Simple Series : SSIS Conditional Split
Conditional Split is a very powerful component, enabling you to send records in different directions or exclude them from the downstream...
2010-03-25
1,128 reads
Virtual Presentation : Index Statistics
I just gave a virtual presentation, courtesy of Pass and the appdev group. The recorded presentation is available here:
Recorded Presentation
A...
2010-03-23
641 reads
Business needs vs dirty reads
I have worked in many industries, but most of my time has been in the publishing industry. For those not...
2010-03-12
295 reads
Managing user data and response through 'drop boxes'
There are a few ways to get data from a client to your system; FTP or email. Internally we tend...
2010-02-24
624 reads
SSIS 2008 Script Component variable gotcha..
In a previous post I showed you how to access variables from within an SSIS script component. More specifically I...
2010-02-22
3,693 reads
SSIS 2008 Script Component variable gotcha..
In a previous post I showed you how to access variables from within an SSIS script component. More specifically I...
2010-02-17
782 reads
SSIS 2008 Script Component variable gotcha..
In a previous post I showed you how to access variables from within an SSIS script component. More specifically I...
2010-02-16
4,569 reads
Covering Index using Included Columns
This article from Josef Richberg details the benefits of included columns for use in creating a covering index to improve performance.
2010-02-11
12,949 reads
I've been published on Simple-Talk.
I am excited to say I have been published on Simple-Talk. This was my first foray into being professionally edited. I...
2010-02-09
327 reads
Blogs
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
My Social Media Rules
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
Why Use TRY_PARSE(): #SQLNewBlogger
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
Forums
Partitioning a table with TEXTIMAGE_ON option
I have a table that ends in ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]. I'm about to...
OUTER APPLY Fundamentals: Part 2
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
Building Great Software
Comments posted to this topic are about the item Building Great Software
Question of the Day
The Range of Customers
I have this data in the OrderHeader table in a SQL Server 2025 database (ordered by CustomerID ASC):
orderid orderdate customerid complete 3 2025-05-10 00:00:00.0002 1 21 2024-01-10 00:00:00.0003 1 15 2023-10-28 00:00:00.0004 1 13 2025-03-08 00:00:00.0006 1 11 2024-04-02 00:00:00.0007 1If I run this query, how many rows are returned?
SELECT * from dbo.OrderHeader where customerid between 3 and '6'See possible answers