Interview with SQL Server MVP Grant Fritchey
Grant Fritchey will be speaking at the SQLServerCentral.com track at SQL Server Connections, October 31-November 3, 2011, in Las Vegas,...
2011-08-23
1,641 reads
Grant Fritchey will be speaking at the SQLServerCentral.com track at SQL Server Connections, October 31-November 3, 2011, in Las Vegas,...
2011-08-23
1,641 reads
Steve Jones will be speaking at the SQLServerCentral.com track at SQL Server Connections, October 31-November 3, 2011, in Las Vegas,...
2011-08-12
1,309 reads
Indexes can be great for boosting the performance of a query, but if an index is never used, it can...
2011-08-11
1,159 reads
Brad's noticed that there are fewer good books about SQL Server on the shelves, and asks which books you'd recommend to people who are new to SQL Server
2011-08-08
404 reads
Reprinted and amended from my editorial at Database Weekly.
For nearly 11 years now, one of the most common questions people...
2011-08-08
1,059 reads
In this article, Brad McGehee takes a brief look at four resource intensive queries that are running on the SQL Server instance that runs the SQLServerCentral.com website. Don't miss out on the competition in this article.
2011-08-02
2,231 reads
Whether it is Transact-SQL for applications you are developing, or just for routine administrative tasks, managing Transact-SQL has never been...
2011-08-01
828 reads
Recently at SQLServerCentral.com, I have been running a series of articles called the SQLServerCentral.com Best Practices Clinic, which describe how...
2011-07-20
531 reads
This is what my audience looked like from the stage just before I started speaking at the first of my...
2011-07-19
997 reads
It’s been my experience that most DBA’s aren’t properly recognized for their contributions to their organizations. As the “protectors of...
2011-07-19
731 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