Fusion-io, Flash NAND All You Can Eat
Fusion-io has announced general availability of the new Octal. This card is the largest single flash based device I’ve ever...
2010-11-19
1,015 reads
Branding, my ass! (Un-SQL Friday 001)
Here is my contribution to my blog party, Un-SQL Friday 001: Branding. Join in the fun, won’t you?
I have a...
2010-11-19
1,016 reads
Denali Paging–Key seek lookups
In my previous post “Denali Paging – is it win.win ?” I demonstrated the use of using the Paging functionality within Denali. ...
2010-11-19
691 reads
I Don't Worry about My Brand
And I guess the experts would say that I probably should. I know that the professional development presentations by Steve...
2010-11-19
1,825 reads
XQuery for the Non-Expert – XMLNAMESPACE
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post.
Talk to the Experts
Let’s talk...
2010-11-19
947 reads
Free Training for the Week of November 22, 2010
Tuesday
Pragmatic Works - Building Calculations in SSAS 2008 - Brian Knight
PASS - PASS Summit 2010 Recap Round Table - Aaron Nelson
I'll be trying to...
2010-11-19
638 reads
Off to the Big Apple
I’m heading to New York today, off for SQL Saturday #59. Another travel day, but I am looking forward to...
2010-11-19
794 reads
Want to Make Your SQL Server Run Faster for Free?
I know I do!
The trick is to properly manage your VLFs.
What are VLFs? The short anser is that VLF...
2010-11-19
2,218 reads
SQL Services on Laptop
I run several SQL Server instances on my laptop, however I’ll keep the services shutdown to conserve resources and then...
2010-11-19
413 reads
Scheduled Out
I’m all scheduled out for the next week with newsletters and content ready to go through Nov 29. I’m not...
2010-11-18
697 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...
ALAMAT BCA KCU TULUNGAGUNG Hub 082225313145
WA CS 082225313145 WWH2+WP2, Jl. Pangeran Diponegoro No.54, Tamanan, Kec. Tulungagung, Kabupaten Tulungagung, Jawa...
OUTER APPLY Fundamentals: Part 2
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
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