Upgrading to SQL Server 2008 - a comprehensive checklist.
There are many considerations and much preparation to do, when a company decides that it is ready to upgrade their...
2010-12-13
13,797 reads
iPads for Christmas
There's a contest going on, today through Friday, and you can win a copy of SQL Monitor from my employer...
2010-12-13
809 reads
SQL Server 2005 SP4
Last year I submitted a Connect item for SQL Server 2005 SP4. Quite a few people supported this item and...
2010-12-13
1,438 reads
All Things Awesome and MidnightDBA-y – 12/9/2010
Here’s the rundown of what we were up to last week
Friday night at 11pm CST we present another wildly appealing...
2010-12-13
811 reads
December PASSMN Meeting This Week
Getting SQL Server for
Christmas! Happy holidays and seasons greetings!
Let PASSMN put a little SQL and PowerShell in your...
2010-12-12
630 reads
SQL Standards
Three posts, three critical rants. It's time to be constructive.
I was given the responsibility to decide on the SQL development...
2010-12-12
1,651 reads
SQLPSX 2.3.1 Release
We’ve released a minor update to SQLPSX which includes several bug fixes as well as two new modules. Here’s an...
2010-12-11
773 reads
SSIS: great idea, but buggy as heck.
Oh SSIS, how I love and hate you.
As DBA at my company, I don't actually develop much in SSIS. But...
2010-12-11
1,791 reads
RTFM365, Week 1
Big lessons learned this week: 1, its’ always worthwhile to go back and reread the basics. 2, sys.sp_trace_create option 4 doesn’t...
2010-12-10
514 reads
Come be your best with Pragmatic Works
Have you been trying to figure out how to take your career in Microsoft BI, SharePoint and SQL Server to...
2010-12-10
514 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