Join the SQL Lunch on Tuesday
What a long week at PASS (stay tuned for more details about my trip). Now that it's over back to...
2010-11-14
673 reads
Cloudy Days Ahead
Microsoft is investing heavily in cloud computing with several online services available
under the Azure Platform.
SQL Azure
The SQL Azure cloud...
2010-11-13
420 reads
PASS 2010 Summit Announcements and New SQL Server Developments
To say that this was a very full conference would be an understatement. The
SQL Server platform has grown to be...
2010-11-13
483 reads
My Fat Finger and the Target Invocation Exception
I was creating an SSIS package recently and ran into the “TargetInvocationException: Exception has been thrown by the target of...
2010-11-12
721 reads
The New Path To MCM
Microsoft has announced changes to the MCM program. This page shows all the ways that you can become an MCM...
2010-11-12
1,333 reads
Troubleshooting SQL Server Error: 18456, Severity: 14, State: 16
I recently had to track down a rogue process that was failing to log in on one of my servers....
2010-11-12
885 reads
PASS Summit 2010-Thursday
Quick recap of yesterday afternoon: blur! I know I did stuff, but the pace is brisk and I’m just keeping...
2010-11-12
547 reads
SSIS : Using variables as a source in a Data Flow Component
Currently, none of the existing Data Flow sources allow you to source variables. Once again in my quest for performance, I look to keep as much data as possible...
2010-11-12
14 reads
SSIS : Using variables as a source in a Data Flow Component
Currently, none of the existing Data Flow sources allow you to source
variables. Once again in my quest for performance, I look to keep as much
data as possible in memory....
2010-11-12
1,229 reads
SSIS : Using variables as a source in a Data Flow Component
Currently, none of the existing Data Flow sources allow you to source variables. Once again in my quest for performance,...
2010-11-12
819 reads
Blogs
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...
A Guatemalan's Guide to Drinking Coffee Properly
My mugI grew up surrounded by coffee farms in Guatemala and somehow spent most...
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