What the heck are you actually using NoSQL for?
It’s a truism that we should choose the right tool for the job. Everyone says that. And who can disagree?...
2014-02-13
517 reads
It’s a truism that we should choose the right tool for the job. Everyone says that. And who can disagree?...
2014-02-13
517 reads
To lower IT operational costs and/or to become more agile, the business must simplify the processes to deliver and manage...
2014-02-13
248 reads
In this series I’m going to detail the 5 T-SQL Commands that review in my 5 T-SQL Commands I’ve been...
2014-02-12
532 reads
Wrote this email exchange with some developer colleagues about to embark on performance tuning.
Subject: bag o' tricks from DMV talk
From: A. Developer
Hey...
2014-02-12 (first published: 2014-02-05)
2,088 reads
Five Tips to Improve Your Data Analysis
It’s no secret that Big Data’s real challenge may not be the technology, but...
2014-02-12
397 reads
Successful organizations place personal development front and center.
from HBR.org http://ift.tt/1aq03xy
via IFTTT
2014-02-12
387 reads
Photo credit – Dennis Wong
A couple weeks back, in a post on certifications, I mentioned the Second Shot offer from Microsoft...
2014-02-12
561 reads
Facilitating employee learning should be a non-negotiable competency. Employee development is one of the most critically important jobs any manager...
2014-02-12
282 reads
Your job is not to maintain the status quo. When you take over a team, you need to evalute why...
2014-02-12
290 reads
Abstract Managing concurrency is one of the most challenging aspects of working with any enterprise DBMS. There is much confusion out there about locking, blocking, and deadlocks. In this...
2014-02-12
11 reads
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
I have a table that ends in ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]. I'm about to...
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
Comments posted to this topic are about the item Building Great Software
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