First take on PowerPivot
What is PowerPivot for Excel? PowerPivot brings the power of Data Modelling into your PC. Traditionally, the DataWarehouse is built...
2013-10-30
1,661 reads
Blog Posts
I’m Attending SQLSaturday #248 in Tampa on Nov 9, 2013
I’ll be heading back to Tampa on November 9, 2013 for the BI Edition of SQLSaturday. I’ll be presenting PCI...
2013-10-30
1,199 reads
Interview With Rick Bolesta of the PASS Board of Directors
Rick Bolesta and Neil Buchwalter of CA technologies are leaving the Board at the end of 2013. CA and Microsoft...
2013-10-30
1,423 reads
Monthly profit percentage techniques
Introduction
A few days ago, a friend of mine approached me with an interesting challenge. What he was trying to achieve...
2013-10-30
1,999 reads
Virtualization for SQL Server DBAs – New SQL Saturday Pre-Con Session
Today I am officially announcing the launch of my first all-day SQL Saturday Pre-Conference training session entitled “Virtualization for SQL...
2013-10-30
1,220 reads
Winner – Conference Pass to SQL Server Live! in Orlando
This is a quick post to announce the winner of our competition for a FREE conference pass to SQL Server Live! in Orlando. Those rather nice folks at SQL Server Live are also offering SQL Brit...
2013-10-30
7 reads
Winner – Conference Pass to SQL Server Live! in Orlando
This is a quick post to announce the winner of our competition for a FREE conference pass to SQL Server Live! in Orlando.
Those rather nice...
2013-10-30
1,369 reads
A look at comments
Everyone knows that we should include comments in our code right? On the other hand the vast majority of us...
2013-10-29 (first published: 2013-10-21)
1,755 reads
Interview FAQ on Interface in C#
What is Interface?
An interface is collection of methods, properties, indexers and events with only signatures. Means In interface Methods, properties,...
2013-10-29
1,586 reads
My First Book: SQL Server 2012 Reporting Services Blueprints
Packt Publishing has published SQL Server 2012 Reporting Services Blueprints – the book that Mickey Stuewe (b | t) and I have...
2013-10-29
1,303 reads
Blogs
Excellent article on securing msdb
By Brian Kelley
Fabiano Amorim has written an excellent article at Simple Talk on securing msdb. Here's...
T-SQL Tuesday #201: Temp Tables
By Steve Jones
This month we have a new host, which I am grateful for. So many...
When Do You Reach For A #temp Table?
I needed to do some research because there is more to #temp tables than...
Forums
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
The Range of Customers
Comments posted to this topic are about the item The Range of Customers
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