SQL Lunch #50 - Solitary Containment (An Overview of SSIS Containers)
Join us tomorrow on the SQL Lunch for a little SSIS.
Topic: #50-Solitary Containment - An Overview of SSIS Containers
If you’ve ever...
2011-03-02
764 reads
I Give Up: What IS an MVP?
I’m so glad you asked!
Here’s how it works: Microsoft makes products. (The one I talk about the most is SQL...
2011-03-02
508 reads
S3OLV March 2011
The Ides of March are upon us and that means that we have another opportunity to learn some stuff about SQL Server. We have that opportunity because it is...
2011-03-02
7 reads
S3OLV March 2011
The Ides of March are upon us and that means that we have another opportunity to learn some stuff about...
2011-03-02
553 reads
How To: Automate Continuous SQLServer Activity with Stored Procedures and Powershell Jobs
The Goal
It’s often useful to be able to run a bunch of stored procedures in the background over a period...
2011-03-02
1,149 reads
TechFuse 2011 – This Month
If you’re looking for a day of training in the Twin Cities, then check out Benchmark Learning’s2011 TechFuse event. The...
2011-03-02
617 reads
Make a Goal! Map it Out! And Go For It!
I can’t tell you that all of your dreams will come true. I won’t tell you that you will make...
2011-03-02
534 reads
SSRS – Creating and Using Shared Schedules – Part 2
In my previous post, I discussed what shared schedules were and how you could use them. With that knowledge under...
2011-03-02
1,927 reads
SQL Server 2008 R2 RTM Cumulative Update 6 Released
Microsoft actually released SQL Server 2008 R2 Cumulative Update 6 on February 21, 2011, so I am a little late...
2011-03-01
1,076 reads
Delimiting Results
Recently, I came across the need to delimit some data in order to be able to test some procedures that I was writing. The procedures need to be able...
2011-03-01
8 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