Favorite DBA Books
In the April 2012 Question of the Month, I asked readers to tell me their favorite DBA books. I have...
2012-05-08 (first published: 2012-05-01)
5,375 reads
In the April 2012 Question of the Month, I asked readers to tell me their favorite DBA books. I have...
2012-05-08 (first published: 2012-05-01)
5,375 reads
Now that SQL Server 2012 has been released, this month’s question is “How soon will you begin implementing SQL Server...
2012-05-01
1,046 reads
This is a reprint from my editorial in Database Weekly. Also, check out the May Question of the Month, as...
2012-05-01
1,251 reads
Having noticed a very low rate of migration to the latest version of SQL Server, Brad McGehee asks - when will you upgrade to 2012?
2012-04-30
746 reads
Red Gate Software and SQLServerCentral.com will be one of the sponsors for the upcoming SQL Server 2012 & SharePoint Connections to...
2012-04-05
1,232 reads
Over and over again, I get asked which DBA books I recommend. With this in mind, this month’s qustion is...
2012-04-01
1,111 reads
Red Gate Software has announced “SQL in the City: London,” to be held on Friday, July 13, 2012, at the...
2012-03-27 (first published: 2012-03-19)
1,599 reads
There is one thing every DBA knows with certainty, and that is that databases grow with time. MDFs grow, backups...
2012-03-13
2,014 reads
I was very surprised to see the results of my latest poll, which asked “When was the last time you...
2012-03-06 (first published: 2012-02-27)
4,828 reads
Tuning poorly performing queries is one of the most important jobs of the DBA. With this in mind, this month’s...
2012-03-01
1,206 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