Something BIG in Boston - SQLSaturday#71
BIG in BOSTON
Last time, I blogged about the first upcoming event in the North East in Philadelphia, PA – SQLSaturday#69, but...
2011-02-02
635 reads
2011-02-02
9 reads
2011-02-02
9 reads
2011-02-02
9 reads
2011-02-02
11 reads
Prepare one box Virtual lab to evaluate SQL Server Denali Always-ON Features
This series of Videos will walk through on how to prepare one box HyperV lab to understand, evaluate & validate SQL...
2011-02-02
724 reads
Work Isn’t the Most Important Thing
I had quite an adventure today, away from work. We had a pipe freeze in the house, a sick kid,...
2011-02-02
1,091 reads
February Question: Share with us your “best” restore disaster stories.
As DBAs, making backups and restoring data is one of the foundational skills we all must master. But sometimes things...
2011-02-01
453 reads
This Month… SSWUG Free SSIS Expo
Stinking Feet?
A couple months back I mentioned the SSWUG Free Expo Event: Basic and Complex SSIS Features. The time has...
2011-02-01
432 reads
Is a clustered index best for range queries?
I see a lot of advice that talks about the clustered index been the best index for use for range...
2011-02-01
1,742 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