SQL Server 2008 R2 Best Practices Analyzer
A big part of my DBA career has centered around identifying and sharing SQL Server DBA best practices. There are...
2010-11-27
2,654 reads
A big part of my DBA career has centered around identifying and sharing SQL Server DBA best practices. There are...
2010-11-27
2,654 reads
Whenever I speak about database maintenance, I always recommend that DBAs backup up their production database transaction logs at least...
2010-11-16
1,871 reads
Tracy Hamlin, selected as the 2010 DBA of the Year, will be awarded her trophy at this year’s SQLServerCentral.com PASS...
2010-11-06
874 reads
This past week, November 3-4, the SQLServerCentral.com track at SQL Server Connections has a record 431 attendees. Below are some...
2010-11-06
663 reads
Database maintenance is a critical task for every DBA. For this month’s question, list the typical steps that you use...
2010-11-03
1,706 reads
Database maintenance is a critical task for every DBA. For this month’s question, list the typical steps that you use...
2010-11-01
1,439 reads
If you are attending SQL Server Connections this week in Las Vegas, be sure to attend some of the sessions...
2010-11-01
630 reads
I recently ran a poll, asking DBAs how often they ran DBCC CHECKDB against their databases. Compared to some of...
2010-10-21
3,078 reads
Life isn't fair, and things don't always go your way. In fact, most people hit a tough patch sooner or later. When that happens to you, how do you respond?
2010-10-18
273 reads
This is a reprint of my editorial in Database Weekly.
Scenario One: The new third-party application, purchased by your company without...
2010-10-17
394 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