January Question: As a DBA, how do you manage your disk space?
Managing disk space is an important resposibility of the DBA, and there are many ways to perform this task. In...
2011-01-05
2,088 reads
Managing disk space is an important resposibility of the DBA, and there are many ways to perform this task. In...
2011-01-05
2,088 reads
I recently held a poll on my blog, asking people if they had attended any SQL Server events in the...
2011-01-03
756 reads
Managing disk space is an important responsibility of the DBA, and there are many ways to perform this task. In...
2011-01-01
2,517 reads
As some of you may have already heard, I spent much of December moving from Hawaii to Missouri. Generally, when...
2010-12-29
1,562 reads
Red Gate Software has released a new, free tool for database administrators and developers called SQL Script Manager. It includes...
2010-12-23
742 reads
2010-12-23
3,466 reads
Things have evolved since the days of essential pagers and landline connections. Or have they? Brad ponders how the nature of remote working is evolving, and invites you help others learn from your experiences.
2010-12-13
179 reads
I have always recommended that DBAs be as proactive as possible, catching potential problems, and actual problems, as soon as...
2010-12-09
1,100 reads
One of the things I promote in all my presentations is the importance of being a proactive DBA. Unfortunately, the...
2010-12-02
620 reads
A big part of my DBA career has centered around identifying and sharing SQL Server DBA best practices. There are...
2010-12-02
1,630 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