Introduction to Partitioning: Resources!
This past Saturday I presented my shiny new Introduction to SQL Server Partitioning session at SQL Saturday 61.
There were two...
2010-12-07
707 reads
SQLRally Call for Speakers Closes December 15, 2010
The call for speakers is open through December 15, 2010, and I hope many of you will take the chance...
2010-12-07
1,194 reads
Not Enough Time
I’ve been thinking about my goals for 2010, ones that I’ve set and adjusted a couple times, and thinking more...
2010-12-07
536 reads
Facebook and E-Mail Security for a New Teenager
Cross-posted from a Goal Keeping DBA blog:
Just recently, my oldest son entered the ranks of the teenagers. I shouldn’t actually...
2010-12-07
2,069 reads
Blog – Domain Changes Update
As I mentioned in an earlier post I have recently moved my blog to a new domain name. This is...
2010-12-07
764 reads
T-SQL Tuesday #13 - What the Business Says Is Not What the Business Wants
It’s time to wrap up T-SQL Tuesday for the year 2010 and I was invited to host his month’s blog...
2010-12-07
8,291 reads
Automating the Processing of a Measure Groups Index Using SSIS
In a recent post (Processing a Measure Groups Index Using SSMS), I showed you how to utilize SQL Server Management...
2010-12-07
1,022 reads
December PASSMN Meeting
Getting SQL Server for
Christmas! Happy holidays and seasons greetings!
True to fashion, the Minnesota SQL Server User Group (PASSMN) is...
2010-12-06
360 reads
Tip: Schema Qualify Objects in SPs
“Eat your broccoli.”
“Wear your gloves.”
“Schema qualify your objects.”
Your Mom wasn’t kidding, and she always gave the best advice. We’ve already...
2010-12-06
1,719 reads
IT Education Part 1
Like many in IT I’m self taught, starting with DOS and batch files, then proceeding through QuickBasic, Visual Basic in...
2010-12-06
620 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