There should only be one ...
When visiting clients, I often find that one or more databases have a table (or several) containing metadata. Most often, these tables have only a single row of data...
2010-11-16
9 reads
There should only be one ...
When visiting clients, I often find that one or more databases have a table (or several) containing metadata. Most often,...
2010-11-16
619 reads
Handy Hardware Assessment Tools For SQL Server
Here is a small selection of useful tools for getting some specific hardware information from any Windows based system you...
2010-11-16
2,258 reads
Backup log Truncate_Only in SQL Server 2008
BACKUP LOG <db_name> WITH truncate_only command, used for clearing the log file, is deprecated in SQL Server 2008. So this post will explain option...
2010-11-16
1,679 reads
My SQL PASS Summit Adventures part 1
I started my PASS Summit a little early this year. I arrived in Seattle on Friday night, November 5th, around...
2010-11-16
591 reads
How Often Do You Backup Your Transaction Logs?
Whenever I speak about database maintenance, I always recommend that DBAs backup up their production database transaction logs at least...
2010-11-16
1,870 reads
Get Drive Space Including Mount Points
Today’s post is a quick one that came out of a conversation on Twitter. To make a long story short,...
2010-11-15
2,851 reads
Help Set Recommendations for SSAS Counters in PAL
First, if you haven’t tried PAL yet, I highly recommend downloading it from CodePlex and giving it a try. You...
2010-11-15
893 reads
PASS Report 1: Why you should have been there!
PASS Summit 2010 is now history. This is my eighth summit but the first one since leaving the DBA world...
2010-11-15
1,562 reads
Inspiration, and the Joy of the Hive Mind
PASS Summit 2010 is over, and we are suffering from the lack of chatter and SQL celebrity sightings. Bloggers are...
2010-11-15
587 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