SQL Saturday SQLSaturday #62 - Tampa Review
For those who attended SQL Saturday #62 in Tampa I hope you enjoyed this free event.As I promised in the...
2011-01-17
1,266 reads
My Prize Has Arrived!
Back in November, I was lucky enough to be nominated and then got enough votes to win the New to...
2011-01-17
548 reads
XQuery for the Non-Expert – @Variable Use
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post.
Talk to the Experts
In a...
2011-01-17
2,710 reads
Multi-subnet Failover Clusters
Multi-subnet Failover Clusters
I want to take a closer look at one of the new features in SQL Server Denali. While...
2011-01-17
4,726 reads
EPM Framework and SQL 2008 R2
This weekend at SQLSaturday 62 in Tampa, I presented my policy-based management presentation. During my presentationone of the cool things...
2011-01-17
1,319 reads
Notes from SQLSaturday #62
The weekend started with a later afternoon drive to Tampa, returning a couple calls and then chatting with Steve Jones...
2011-01-17
621 reads
Isolation Levels–MCM Prep
I was watching the Isolation Levels video for my MCM prep and learned something about the isolation levels. I knew...
2011-01-17
1,329 reads
Using the MERGE statement
I love MERGE. You know all those awful IF BEGIN END ELSE BEGIN END blocks you need to write for...
2011-01-17
4,088 reads
2011.....So (long pause), what's next for me?
I've actually sat down to write this blog several times. I am never indecisive when it comes to my thoughts...
2011-01-17
1,078 reads
TechEd: Session Preference Survey
TechEd has listed some potential sessions for TechEd North America 2011 here: http://northamerica.msteched.com/sessionpreference?fbid=I1Ydc71JM4a. They want to know which sessions you...
2011-01-17
514 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
BCA KCU MOJOKERTO Hub 0822 2531 3145
WA CS 082225313145 Jl. HOS. Cokro Aminoto No.5, Mergelo, Jagalan, Kec. Magersari, Kota Mojokerto,...
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
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