Scary DBA Takes Over the World
Or, at least gets translated into Russian.
I realize I’m effectively a 10 year old, but, come on, HOW COOL IS...
2010-10-15
606 reads
Inappropriate PASS Sessions – SOLD OUT!
I’m sorry, but the Inappropriate PASS Sessions event (an after-hours event during the PASS Summit in Seattle) is SOLD OUT.
This all...
2010-10-15
755 reads
Inappropriate PASS Sessions – nearly SOLD OUT!
If you want to get into the Inappropriate PASS Sessions event during the PASS Summit in Seattle this year, you’d better...
2010-10-15
620 reads
S-3-X Talk Week: Wrapup
Image is conjecture; accuracy of percentages not guaranteed (but likely)
We’ve discussed thinking about 53x (Women: whenever it comes up; Men:...
2010-10-15
591 reads
SQLSaturday #49 tomorrow!
This is just a quick note to let you know SQLSaturday #49 in Orlando is tomorrow! If you’re in the...
2010-10-15
399 reads
SQLSaturday#59 Speaker Interview Series #4 – with Janakiraman Sattainathan
SQLSaturday #59 Speaker Interview Series #4 – with Janakiraman Sattainathan
So far, we went Way out West, NYC local, we were waiting...
2010-10-15
807 reads
Free SQL Server Training for the Week of October 18, 2010
Tuesday
PASS - 24 Hours of PASS - LATAM: All Sessions in Spanish or Portuguese
Pragmatic Works - SQL Statement Tuning with Indexing Strategies - Kevin...
2010-10-15
789 reads
Kindle v iPad
I don’t have either, but I ran across this comparison on the devices. It says get both, if you’re a...
2010-10-15
897 reads
Using Symlinks in PowerShell Scripts
Symlinks are heavily used in Linux/Unix environments to provide an abstraction for file and directory locations and with the introduction...
2010-10-15
1,548 reads
Andy Warren’s Word Counter
I typically don’t blog about other people blogs, because quite frankly I don’t like giving summations of the work someone...
2010-10-14
649 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