Template for Tracking Professional Development
One of the ideas I mentioned in my presentation on Comprehensive Professional Development was to set up some type of...
2010-11-17
1,809 reads
A Plug for SQLSaturday #45 in Louisville
My friend Mala is heading up the 2nd annual SQLSaturday in Louisville, KY, being held next year on January 22,...
2010-11-17
483 reads
The 2010 SQLServerCentral Party
A quick look at the SQLServerCentral party at the 2010 PASS Summit, thanks to SQLChicken. It’s on UStream
Not great quality,...
2010-11-17
808 reads
SQLSaturday#59 NYC 2010 - 3 Days Away! - Sponsor Profile
SQLSaturday#59 is only a mere 3-days away! Today, I am bringing you a sponsor profile for our participating vendors, who...
2010-11-17
651 reads
Cleaner Code Demos – Speaker Hints
Recently I had the privilege of watching Paul Randal and Kimberly Tripp present (separately) at SQL Server Connections. If you...
2010-11-17
841 reads
Powershell: Calculating Seven Day Retention for Security Event Logs
I needed to figure out how much space was required to maintain 7 days of event log entries for the...
2010-11-17
2,350 reads
Handling Type II Dimension with the MERGE Statement
Microsoft attempted to make our lives easier with the Slowly Changing Dimension task in SSIS. However, as we all know...
2010-11-17
2,011 reads
Dynamically Backing Up All User Databases in SQL Server
I recently had a request from a client to come up with a routine to do a full compressed database...
2010-11-16
1,419 reads
SQL Server Team-Based Development
The new book is available in a free download from Red Gate. I had a lot of fun working on...
2010-11-16
1,169 reads
PASS Summit Report 2: Seattle Again?
There is always a lot of talk about the fact that we have been in Seattle several years in a...
2010-11-16
1,155 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...
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