Motivational Monday
In life there are not many guarantees. For DBA’s and developers there are a few:
1. Backups will become corrupted but...
2010-11-01
399 reads
More Voting
As if the US Election and SQL Rally voting were not enough (and have you voted yet for the SQL...
2010-11-01
648 reads
November Snuck Up on Me
I should have gotten this post out last week with another follow-up this week. Well, looks like I will have...
2010-11-01
455 reads
Fusion-io, What It Takes To Be On The Cutting Edge
I recently had the privilege to talk with David Flynn, former CTO, Founder and newly minted CEO about Fusion-io. How...
2010-11-01
1,527 reads
SQLSaturday#59 Update! - 3 weeks to go.....the after PASS East Coast Special!
SQLSaturday#59 Update!
Well, the event is now less than 3 weeks away (better finish my presentation 🙂 and there are 450+ attendees...
2010-11-01
567 reads
Android Adventures–Part 1
I’ve used a Blackberry for the better part of 10 years, loyalty built because as a phone and an emailing...
2010-11-01
389 reads
Finding Your Dream Job
My pre-conference session for the SQL Rally conference in the spring is called “Finding Your Dream Job”. Chris Shaw ( LinkedIn...
2010-11-01
658 reads
November Question: What steps do you include in your database maintenance?
Database maintenance is a critical task for every DBA. For this month’s question, list the typical steps that you use...
2010-11-01
1,438 reads
Rescheduled: SQL Lunch #42 - Auditing Database Permissions in SQL Server
Last Wednesday I woke up feeling under the weather with a hoarse voice. I wasn't up to doing the presentation...
2010-11-01
709 reads
Leaving (for) Las Vegas
Tomorrow I’m off to Las Vegas for SQL Connections. Since tomorrow is also T-SQL Tuesday #012, I’m writing a pre-trip...
2010-11-01
429 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