SQL in the City: Free SQL Server Events in London and Los Angeles
Red Gate Software has announced two free, full-day SQL Server events, called “SQL in the City”. Both events will provide...
2011-04-01
773 reads
Red Gate Software has announced two free, full-day SQL Server events, called “SQL in the City”. Both events will provide...
2011-04-01
773 reads
This past week, about 1,200 developers, IT professionals, and DBAs spent three days attending DevConnections at the J.W. Marriott Resort...
2011-04-01
784 reads
If you are thinking about attending SQL Server Connections (a part of DevConnections) in Orlando this March 27-30, take advantage...
2011-03-11
638 reads
After attending the SQLskills Immersion Event on Internals and Performance in Dallas two weeks ago, I am fortunate enough to...
2011-03-10
817 reads
Lock Pages in Memory is a setting that can be set on 64-bit operating systems that essentially tell Windows not...
2011-03-10
3,114 reads
Brian Kelley will be speaking at the SQLServerCentral.com track at SQL Server Connections, March 27-30, in Orlando, FL.
Tell us a...
2011-03-10
936 reads
Joe Webb will be speaking at the SQLServerCentral.com track at SQL Server Connections, March 27-30, in Orlando, FL.
Tell us a...
2011-03-10
1,034 reads
If you are thinking about attending SQL Server Connections (a part of DevConnections) in Orlando this March 27-30, take advantage...
2011-03-10
818 reads
I have just begun a new article series at SQLServerCentral.com called the SQLServerCentral.com Best Practices Clinic. What is this series...
2011-03-07
661 reads
As DBAs, we have all received a phone call from a database user, asking why the database is so slow....
2011-03-01
604 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