SSAS – Hiding Unknown Member
You may have noticed when creating Analysis Services dimensions that a member is created in all of your attributes that...
2011-01-10
14,907 reads
PASSMN Call for Presenters and Sponsors
Before the year gets going too far and things are too planned out, I thought I would see if there...
2011-01-10
417 reads
My First Sandy Bridge Desktop System
I was standing in line at the Denver Micro Center at 11AM this morning (despite the beginnings of a small...
2011-01-10
1,407 reads
Thinking about goals for 2011
The SQL community is inspiring, and there are a lot of people that work hard to contribute to it. With...
2011-01-10
1,034 reads
SSMS Addin Wrapper - Source Code and Usage
Code First, KTHX!
Here, as promised, is the source code for the SSMS wrapper.
Introduction
My apologies for the brief delay on this....
2011-01-10
2,382 reads
31 Days of SSIS – Override Variables (9/31)
Day number 9 of the 31 Days of SSIS. If you missed the first week then start by reading the...
2011-01-09
1,042 reads
The OUTPUT clause
One of the features that I have been using quite a lot lately is the OUTPUT clause.
This clause can be...
2011-01-09
934 reads
SSMSDeploy - Demo Video Available!
Updates
1) I have discovered that there was already a tool called SQL Deploy, so I have renamed my addin to...
2011-01-09
589 reads
31 Days of SSIS – Merge Join Is My Friend (8/31)
31 Days of SSIS
Welcome to day eight post for the 31 Days of SSIS. If you are just joining the...
2011-01-09
835 reads
Changes to the PASS Board
The official announcement was posted yesterday that Jeremiah Peschka and Brian Moran have decided to resign from the Board and...
2011-01-09
703 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