“Wear Your SQL Saturday Shirt Day”
Over the past year there have been a number of SQL Saturday events. These events have occurred across the country...
2010-11-01
878 reads
Vote for Our SQL Rally PreCon
VOTE VOTE VOTE VOTE VOTE VOTE VOTE!!!!!!!!!!
Vote here: http://www.zoomerang.com/Survey/WEB22BD59JCQBT
Honestly, I want each of reading my blog to vote for our...
2010-11-01
491 reads
SQLServerCentral.com Track at SQL Server Connections This Week
If you are attending SQL Server Connections this week in Las Vegas, be sure to attend some of the sessions...
2010-11-01
630 reads
Database Security Best Practices for the Vigilant Database Administrator and Developer (Unabridged Edit)
Below is a longer version of the equivalent Technet Article under Security TechCenter > Learn > Security Columns > MVP Articles > Database Security Best PracticesThe security of...
2010-10-31
5,327 reads
Get Out The Vote
It’s actually kind of cool that SQL Rally voting for the pre-conference seminars and voting in the real(ish) world in...
2010-10-31
1,668 reads
I’m starting my own SQL Server Consulting business!
Beginning with tomorrow I’m no longer working for HP Austria, because I’m starting
my own SQL Server Consulting business. I’ve been...
2010-10-31
1,538 reads
Why do you use Sparse Columns ? (by Abi Chapagai)
What uses have you found for sparse columns in your databases?
SPARSE columns is a new feature in SQL Server...
2010-10-31
2,602 reads
Speaking at SQL Server Connections in Las Vegas Next Week
I will be giving two presentations next week at the SQL Server Connections conference in Las Vegas. There is a...
2010-10-31
1,581 reads
WorldWide Online Tech Day 2010
Hate to post this late but just wanted to let everyone know I’ll be presenting for Brazil’s Worldwide Online Tech...
2010-10-29
1,470 reads
Scary DBA Halloween Special
Not so much my special as SQL Saturday #59's Special. These guys in NYC are pulling out all the stops....
2010-10-29
1,386 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
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