SQL Server 2008 R2 SP2 CU11
On February 17, 2014, Microsoft released SQL Server 2008 R2 SP2 CU11, which is Build 10.50.4302. This cumulative update has...
2014-02-21
1,381 reads
Blog Posts
SQLSaturday #273 In Tampa This Weekend
I’m looking forward to the trip to Tampa for SQLSaturday #273 this weekend. I’m driving down this afternoon to beat...
2014-02-21
647 reads
Toyota Land Cruiser Fj40 Diesel Engine Swap – #dieselisbetter
Toyota Land Cruiser Specialists (TLC) has taken its restoration business a step further and started offering its own line of...
2014-02-21
842 reads
Up Coming Speaking Events
Hello Dear Reader! We are 2 months into 2014 and the New Year is off to a busy start. This...
2014-02-21
735 reads
Walmart Store Openings through Power Map
A couple weeks back, I was taking a look at a map that had been put together on Flowing Data...
2014-02-21 (first published: 2014-02-18)
2,390 reads
101 Whiskies to Try Before You Die #whiskey
In his new book “101 Whiskies to Try Before you Die” whisky expert Ian Buxton poses the fun challenge of...
2014-02-20
715 reads
Annoying Recruiters
In a follow-up to my blog post Low-rate recruiters – The bane of my existence, Michael Bramante (website) wrote me a...
2014-02-20
1,300 reads
Attach Database “Operating System Error 5 (Access is denied)” MSSQL Server 2012.
When I try to attach mdf file I got following error below.
Solution:
There are multiple solutions to this
1 1. Move .mdf and .ldf to SQLServer install directory Data folder...
2014-02-20
51 reads
Finally added a (t) to my (b)
I feel like an old man opening a computer for the first time but I’ve finally signed up on twitter....
2014-02-20
510 reads
Last Weeks Top “Reading” Links #71
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-02-20 (first published: 2014-02-17)
1,818 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