SQL Server 2005 SP3 Cumulative Update #15
Microsoft has released SQL Server 2005 SP3 Cumulative Update 15, which is Build 9.0.4325. There are only six fixes included...
2011-03-22
686 reads
SSAS - Measures or Attributes in Multiple Display Folders
I had a client recently show me a neat little tip that I thought I would share.In the cube he...
2011-03-22
1,283 reads
SSAS errors: Errors in the metadata manager. The dimension with ID of ‘xxx’ referenced by the ‘yyy’ cube, does not exist.
When deploying or processing a cube or dimension you may encounter an error similar to this:
Errors in the metadata manager. The...
2011-03-22
1,263 reads
Database Mail – Collection of SQL Server Scripts
As part of my blogging I’ll be periodically providing readers with a collection of my scripts which I use on...
2011-03-21
942 reads
SSIS Foreach File Enumerator returns more files than expected by appending a wildcard (*) to the file mask
While working on a recent project for a customer that involved importing both Excel 97-2003 and Excel 2007/2010 files, I was...
2011-03-21
1,310 reads
21st March - Today is International Day for the Elimination of Racial Discrimination
How to Counter Intolerance, Adapted from UNESCO’s Recommendations
1. The Battle Against Intolerance Requires Law
Every Political Entity needs to reinforce Human...
2011-03-21
1,112 reads
SQL Server Connections in a week
I’m heading to SQL Server Connections next week, part of the DevConnections conference featuring a whole slew of technologies. Once...
2011-03-21
791 reads
Dedupe Data CTE
As a DBA working with SQL Server, some data issues arise that need to be fixed. One such data issue is the duplication of data. Duplicate data can happen...
2011-03-21
22 reads
Dedupe Data CTE
As a DBA working with SQL Server, some data issues arise that need to be fixed. One such data issue...
2011-03-21
1,393 reads
Blog Syndication
I got sent an email recently asking how I went about syndicating my blog on some of the popular SQL...
2011-03-21
1,739 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