Make the 2009 PASS Summit Better: Offer Your Speaking Tips to Others
This year, I was asked to participate on the PASS Program Committee Management team as the “Speaker Manager.” One of...
2009-03-13
847 reads
This year, I was asked to participate on the PASS Program Committee Management team as the “Speaker Manager.” One of...
2009-03-13
847 reads
At the recent MVP conference I attended, Microsoft filmed a promotion for their ad campaign. They had the entire MVP...
2009-03-06
656 reads
If you are thinking about, or planning to attend the 2009 PASS Community Summit, here is your opportunity to tell...
2009-03-06
451 reads
The BoiseCodeCamp and TechFest will be held Saturday, March 28th at Boise State University. This free event include 57 one-hour...
2009-02-26
1,387 reads
If you are interested in speaking at the devLINK Technical Conference in Nashville, TN, August 13-15th, you need to get...
2009-02-25
1,350 reads
Microsoft has introduced a new website (part of Microsoft.com) called Thrive. It is still in its infancy, but its focus...
2009-02-25
1,372 reads
Backup verification is a vital part of a well-designed database maintenance plan and yet some DBAs neglect to do it. Brad McGehee ownders why.
2009-02-24
747 reads
If you use Data Dude (Visual Studio 2008 Team System Database Edition GDR), you might want to check out Gert...
2009-02-20
649 reads
I have always been of the personal opinion that all SQL Server tables have a clustered index. As part of the research I am doing on a new book on High Performance Index Maintenance , and on heaps specifically, I ran across this SQL Server Best Practices...
2009-02-20
5,000 reads
As some of you may know, I am writing a new book called High Performance Index Maintenance. As an experiment...
2009-02-19
811 reads
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
I have a table that ends in ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]. I'm about to...
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
Comments posted to this topic are about the item Building Great Software
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