Why I’m All For 24HOP Showcasing 24 Women Speakers
This is not the HOP you are looking for.
I’ve been thinking about the upcoming 24HOP event planned for March 15...
2010-12-27
972 reads
Rebuilding my laptop
I finally got around to adding the new memory (16GB), removing the old 4GB and then replacing the DVD drive...
2010-12-27
805 reads
MVP Program
There is one thing that have been bothering me for quite some time. I thought I would blog about it....
2010-12-27
1,286 reads
The Twelve Days of (SQL) Christmas
Once upon a time a group of twelve bloggers agreed to each pick a post (or posts) they found interesting...
2010-12-27
1,957 reads
Script Drop all tables of a database
Hi people, following a script that deletes all tables in a database. Enjoy.
SET NOCOUNT ON;
DECLARE @Tabela TABLE
( Seq INT,...
2010-12-27
2,101 reads
The MCM Journey
I’m not really planning on getting the MCM. Perhaps I’ll change my mind, but it’s not the time for me...
2010-12-27
848 reads
SQL Server Storage Internals Part 5 - Properties of Clustered and Non Clustered Index pages
In this article, I thought of explaining different types and levels of index pages. but while start preparing for that, I realise...
2010-12-27
9,514 reads
PBM and PowerShell
The best new management feature added to SQL Server 2008 is Policy Based Management or PBM. PBM allows DBAs to...
2010-12-25
2,361 reads
Merry Christmas
This is just a short post for a Friday and not just any old Friday either, Santa is on his...
2010-12-24
563 reads
Server Side trace
Most of us are aware of tracing queries using SQL profiler. But an effective way of performing tracing is using...
2010-12-24
510 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