But We Have Always Done It That Way
I recently ran across the following scenario. A SQL Server instance had been upgraded from SQL Server 2005 to SQL...
2010-02-02
2,081 reads
I recently ran across the following scenario. A SQL Server instance had been upgraded from SQL Server 2005 to SQL...
2010-02-02
2,081 reads
Not all DBAs have the opportunity to attend formal classroom training or attend conferences. While there are many SQL Server...
2009-11-23
841 reads
SQL Server MVP Deep Dives, a new book written by 53 SQL Server MVPs, is now available as an eBook,...
2009-10-12
785 reads
I am in the process of creating a new blog, but I am having difficulty coming up with a good name. I would like to go with a Hawaii-based theme on the blog, so a Hawaii-based name would be great.
2009-07-20
541 reads
In the last year or so, there have been a lot of articles, blog entries,and forum posts on the kinds of technical questions hiring managers can ask a prospective DBA candidate in order to determine their technical proficiency. While technical skills are...
2009-07-06
2,966 reads
Brad McGehee provides a "career guide" for DBAs. It is intended both to help prospective DBAs find a "way in" to the profession, and to advise existing DBAs on how they can excel at their jobs, and so become Exceptional DBAs.
2009-06-03
6,643 reads
The sixth and last module of the training course "Becoming a Profiler Master", describes how to create custom Profiler traces, tailored to the specific performance problem you wish to investigate.
2009-05-21
9,170 reads
The fifth module of the training course "Becoming a Profiler Master", looks in details at the data columns that are associated with the Profiler events discussed in module 4.
2009-05-19
9,787 reads
The fourth module of the training course "Becoming a Profiler Master", takes a detailed look at the many events and event categories that can be collected with Profiler.
2009-05-14
8,459 reads
This, the third installment of the "Becoming a Profiler Master" online training course, shows how to start, stop and control Profiler and how to save the traces.
2009-05-12
8,975 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