T-SQL Tuesday 14: Techie Resolutions for You not Me
Is it just me or has the community done the whole “What are my goals for this year” thing to...
2011-01-11
656 reads
SQLBits Will be Held in Brighton England in April
SQLBits, the largest SQL Server conference is Europe, will be held this April 7-9, 2011 in Brighton, England at the...
2011-01-10
562 reads
DevTeach/SQLTeach Montreal 2011 Registration is Now Open
The recently resurrected DevTeach/SQLTeach event will be held May 31 through June 2, 2011 in Montreal, Canada at the Montreal...
2011-01-10
650 reads
Speaking at SQLSaturday #62–Tampa
I’ll be speaking at SQLSaturday #62 – Tampa this Saturday, January 15th. I’ll be presenting: Why I Use Stored Procedures With the...
2011-01-10
10 reads
Fun with Extended Properties in SQL Server 2008
Most technical professionals don’t seem to enjoy writing and maintaining documentation for their databases. I know that documentation falls pretty...
2011-01-10
3,400 reads
31 Days of SSIS – Pivot Transformation (10/31)
A few months back, well before the 31 Days of SSIS started, I had been playing with the Pivot Transformation. ...
2011-01-10
1,192 reads
Top 10 SQL #Awesomesauce for 2010
Here at MidnightDBA.com, we’re all about you! And us! It’s just us, and you. Which is why I’ve put together...
2011-01-10
810 reads
Speaking at SQLSaturday #62–Tampa
I’ll be speaking at SQLSaturday #62 – Tampa this Saturday, January 15th. I’ll be presenting:
Why I Use Stored Procedures
With the proliferation...
2011-01-10
772 reads
SSC Editorial: Clouds in our Future
I wrote Clouds in our Future to see if I could spark a good conversation about the mental shift required...
2011-01-10
609 reads
How SQL Server stores indexes on variable length columns
In the last months I had done a lot of performance tuning workshops, and there is
almost the same question: How...
2011-01-10
2,377 reads
Blogs
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
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...
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