T-SQL Tuesday #016: Aggregates and Statistics
Data Size Collection and Analysis
By now you should be well acquainted with this phenomenon we call TSQL Tuesday. This party...
2011-03-08
680 reads
Visual Studio 2010 SP1 Released
Microsoft has released the RTM version of Visual Studio 2010 SP1, which is available on the MSDN Subscribers web site.
Microsoft’s...
2011-03-08
755 reads
Full backups, the log chain and the COPY_ONLY option.
There have been a large number of posts made regarding the interaction between full database backups and the log chain...
2011-03-08
1,345 reads
An Overview of SQL Server AlwaysOn
One of the changes coming in SQL Server v11 (not sure what the name will actually be), also known as...
2011-03-08
921 reads
Firefox and Reporting Services
Not everyone uses IE and that’s ok, but what’s strange is that by default if you point Firefox at a...
2011-03-08
863 reads
Come on Out to OPASS
Tonight is the March OPASS meeting. You should come on out, it’s always a great time. Note our new location and be sure to RSVP so we can have...
2011-03-08
7 reads
Speaking at Orlando Code Camp on March 26, 2011
I’ll be speaking at the upcoming Orlando Code Camp on March 26, 2011, at Seminole State College in Lake Mary....
2011-03-08
1,222 reads
SQLSaturday #77 in Pensacola–Call for Speakers
Karla Landrum just announced SQLSaturday #77, coming to Pensacola on June 4, 2011. Pensacola is a great weekend destination, hit...
2011-03-08
864 reads
Customizing Report Manager Should Be Easier
You might be reading this hoping that I have the magic answer on how to make the Report Manager portal...
2011-03-08
684 reads
Aggregating With Correlated Sub-Queries #tsql2sday
It’s that time of the month again. Time for T-SQL Tuesday! This month’s event is being hosted by Jes Schultz...
2011-03-08
695 reads
Blogs
My Social Media Rules
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
Why Use TRY_PARSE(): #SQLNewBlogger
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
A Guatemalan's Guide to Drinking Coffee Properly
My mugI grew up surrounded by coffee farms in Guatemala and somehow spent most...
Forums
Alamat Kantor BCA KCU Subang Telp:08218154374
Hub Via Wa:628218154374 Alamat Jl. Otto Iskandardinata No.37, Karanganyar, Kec. Subang, Kabupaten Subang, Jawa...
Alamat Kantor BCA KCU Purwakarta Telp:08218154374
Hub Via Wa:628218154374 Alamat Bank Bca Kcu Purwakarta, Jl. Jendral Sudirman No.85, Nagri Tengah,...
Alamat BCA KCU Soekarno Hatta Telp:08218154374
Hub Via Wa:628218154374 Alamat Jl. Soekarno-Hatta No.240, Kb. Lega, Kec. Bojongloa Kidul, Kota Bandung,...
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