SQL Server Virtual Machine vNUMA Sizing
A wonderful gentleman who attended my SQL PASS Summit session this year recently emailed me and asked me a great...
2013-12-10 (first published: 2013-12-02)
2,145 reads
Blog Posts
To DBA or Not to DBA (DBA Jumpstart)
This post is part of the SQL Community Project started by John Sansom called #DBAJumpStart.“If you could give a DBA...
2013-12-10
826 reads
To DBA or Not to DBA (DBA Jumpstart)
This post is part of the SQL Community Project started by John Sansom called #DBAJumpStart. “If you could give a DBA just one piece of advice, what would it...
2013-12-10
5 reads
T-SQL Tuesday #49: My Go-To Query For Waiting Tasks
I’m not just hosting T-SQL Tuesday, I’m a customer as well. Err, I mean participant. Topic for this month’s T-SQL...
2013-12-10
1,228 reads
T-SQL Tuesday #49: Using CXPacket Waits to Detect Query Bottlenecks
This post is for T-SQL Tuesday #49, the monthly blog party of the community.
This tradition was started by Adam...
2013-12-10
1,449 reads
T-SQL Tuesday #49: Wait for it
It’s T-SQL Tuesday again and this time it’s being hosted by the SQL Soldier. He’s picked the subject of Waits....
2013-12-10
859 reads
T-SQL Tuesday#49 - Wait for it...Waits & Queues
As
I was waiting for the next TSQL
Tuesday topic to be announced, we all know that when SQL Server performance is
slow,...
2013-12-10
1,608 reads
#TribalAwards with RedGate!
You know what? You’re doing a good job. You’re reading blogs, and that’s generally the sign of a person wanting...
2013-12-09
573 reads
Back to iOS from Android
I pre-ordered a Samsung Galaxy S4 last spring, after listening to my wife talk about how much happier she was...
2013-12-09
590 reads
Backups and Giveaways! Day 1
We have 16 days until Christmas. Since I started this blog, I've posted every day Monday through Friday. I am...
2013-12-09
372 reads
Blogs
T-SQL Tuesday #201 - Temp Tables, Friend or Foe?
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
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...
Forums
Partitioning a table with TEXTIMAGE_ON option
I have a table that ends in ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]. I'm about to...
ALAMAT BCA KCU TULUNGAGUNG Hub 082225313145
WA CS 082225313145 WWH2+WP2, Jl. Pangeran Diponegoro No.54, Tamanan, Kec. Tulungagung, Kabupaten Tulungagung, Jawa...
OUTER APPLY Fundamentals: Part 2
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
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