DBCC TraceOn – some processes are global.
Hi,
I was recently doing some testing as I thought that I’d experiment with the ghost clean up process.
I found that...
2011-04-13
2,657 reads
T-SQL Tuesday #17 – APPLY Knowledge
It’s that time of the month again… again. Time for T-SQL Tuesday! This month’s event is being hosted by Matt...
2011-04-12
1,244 reads
PASS SQLRally–Thoughts from an Organizer
There have been lots of blog posts about PASS SQLRally (Bing Search), but there haven’t been a lot recently from the organizers. As today (April 12th) is the last day...
2011-04-12
9 reads
A SQL Server Hardware Nugget A Day – Day 12
In Day 12 of this series, we will be talking about AMD Opteron Processor Numbering. Advanced Micro Devices (AMD) has...
2011-04-12
756 reads
T-SQL Tuesday #17 – APPLY Knowledge
We have another opportunity to write as a part of TSQL Tuesday today. This month Matt Velic (Blog | Twitter). Matt has proposed a challenge that was derived from...
2011-04-12
7 reads
T-SQL Tuesday #17 – APPLY Knowledge
We have another opportunity to write as a part of TSQL Tuesday today. This month Matt Velic (Blog | Twitter). Matt...
2011-04-12
530 reads
Close, but no MCM Cigar
I failed.
There’s no other way to say it, but I’m not really disappointed or discouraged. I’m actually fairly upbeat about...
2011-04-12
1,201 reads
SSRS 2005 Error: The Declare cursor SQL construct or statement is not supported
Few days back I downloaded a SSRS 2005 file from one of our internal report server and started modifying it....
2011-04-12
2,891 reads
It's not about whether you're a consultant or full-time staff...
There's an article that's making its way through the SQL Ranks: Consultants are pros, while corporate IT staff are minor...
2011-04-12
1,337 reads
PASS SQLRally–Thoughts from an Organizer
There have been lots of blog posts about PASS SQLRally (Bing Search), but there haven’t been a lot recently from the...
2011-04-12
844 reads
Blogs
Excellent article on securing msdb
By Brian Kelley
Fabiano Amorim has written an excellent article at Simple Talk on securing msdb. Here's...
T-SQL Tuesday #201: Temp Tables
By Steve Jones
This month we have a new host, which I am grateful for. So many...
When Do You Reach For A #temp Table?
I needed to do some research because there is more to #temp tables than...
Forums
OUTER APPLY Fundamentals: Part 2
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
Building Great Software
Comments posted to this topic are about the item Building Great Software
The Range of Customers
Comments posted to this topic are about the item The Range of Customers
Question of the Day
The Range of Customers
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