SQLServerCentral.com Track at SQL Server Connections This Fall in Las Vegas
As has now become a regular tradition, SQLServerCentral.com is providing an educational track at SQL Server Connections (part of DevConnections)...
2011-07-18
2,250 reads
As has now become a regular tradition, SQLServerCentral.com is providing an educational track at SQL Server Connections (part of DevConnections)...
2011-07-18
2,250 reads
I have been a judge for the Exceptional DBA of the Year Awards ever since its inception, and one of...
2011-07-08
1,182 reads
While being a DBA is challenging and often rewarding, we often experience a lot of pain points that we wish...
2011-07-01
688 reads
Reprinted from my editorial in Database Weekly.
In early 2000, I started a new DBA job with a large organization, as...
2011-06-27
936 reads
There is now a vast amount of SQL Server information and 'best practice' advice available on the Internet, in the form of innumerable blogs, community sites and forums. Finding an answer to your question is relatively easy, but finding the right, or best, answer is harder than ever.
2011-06-27
483 reads
In this next installment looking at implementing best practices here at SQLServerCentral, Brad McGehee looks at a few performance counters and what they tell us about the performance of our database server.
2011-06-06
4,497 reads
Every since the first file was written to a floppy disk drive using DOS, physical file fragmentation has been a...
2011-06-01
1,994 reads
As DBAs, one of our biggest responsibilities is to monitor our SQL Servers to ensure they are performing as expected....
2011-06-01
1,251 reads
This year’s devLINK Technical Conference will be held at the Chattanooga Convention Center, Chattanooga, TN this upcoming August 17-19, 2011....
2011-05-25
642 reads
SQLServerCentral.com, along with Red Gate Software, are glad to announce that nominations for the fourth annual Exceptional DBA Awards are...
2011-05-25
1,434 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