Wiring up a common click event handler in an ASP.NET page
I was just refactoring a server-side control and ran into some horrible code. Basicaly there was a big listbox that...
2010-12-30
3,115 reads
Reviewing My 2010 Goals
You can go over my goals here. I’ve really hesitated to do this post because, in my opinion, I did...
2010-12-30
1,427 reads
MCM Prep - VLF Allocations
I had heard that you could have too many VLFs in your transaction log, and it could cause performance issues....
2010-12-30
1,939 reads
A Change of Pace
As some of you may have already heard, I spent much of December moving from Hawaii to Missouri. Generally, when...
2010-12-29
1,562 reads
Updated SQL 2005 and 2008 Diagnostic Queries
Since it is almost January 2011, I thought I would post the January 2011 versions of the SQL Server 2005...
2010-12-29
2,281 reads
Looking Back at 2010–Goal Review
I had 8 goals for 2010, which I posted at the end of last year. That reminds me, I need...
2010-12-29
1,828 reads
SQLMeetings.com Is Live!
You heard right, I’ve finished with the 1.0 release. It isn’t pretty but it works. If you need a primer...
2010-12-29
1,564 reads
Book Review: Bury My Heart at Conference Room B
Bury My Heart at Conference Room B: The Unbeatable Impact of Truly Committed Managers by Stan Slap ($15 @ Amazon) is...
2010-12-29
738 reads
Quick Thoughts on Learning
I’m looking for the attribution for a quote – it’s something I first heard from Sean, and we say it all...
2010-12-29
507 reads
Digineer Is Hiring
If you are in Minnesota and are looking for a new job, Digineer is hiring. Heck you can even be...
2010-12-29
600 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