Getting Live with SFSSUG
Hey folks, I recently had the privilege of joining my hometown user group South Florida SQL Server User Group for...
2010-11-08
372 reads
SATA, SAS or Neither? SSD’s Get A Third Option
I recently wrote about solid state storage and its different form factor. Well, several major manufacturers have realized that solid...
2010-11-08
545 reads
Date Dimension Using Computed Columns
Picked up this nice script from a client last week. Use this script below to create a Date Dimension for...
2010-11-08
1,137 reads
Successful Teams: Knowing When to Step Out of Your Role
I've talked about the fact that everyone needs to contribute for the success of the team and that everyone should...
2010-11-08
1,456 reads
Do You Need a Mentor?
When I was young, I never thought I did. I was sure that I knew what was best for my...
2010-11-08
1,039 reads
Pass Summit Sunday Morning
I’m sitting in Top Pot Donut. I’m having a fantastic apple fritter. I’m also trying out the capabilities of the...
2010-11-07
564 reads
Quick Elevators
I’m at the Renaissance in Seattle for a couple days, stuck on the 14th floor. That’s higher than I normally...
2010-11-07
459 reads
SQLPSX 2.3 Release
Just in time for PASS Summit 2010, the CodePlex project SQL Server PowerShell Extensions (SQLPSX) has been updated . Here’s a...
2010-11-06
2,165 reads
2010 DBA of the Year Will be Awarded at SQLServerCentral.com PASS Opening Night Party
Tracy Hamlin, selected as the 2010 DBA of the Year, will be awarded her trophy at this year’s SQLServerCentral.com PASS...
2010-11-06
874 reads
SQLBIGeek’s Function Friday – Return First Date of Month
Brian K. McDonald
SQLBIGeek
Twitter: @briankmcdonald
Welcome to the third post of my “SQLBIGeek’s Function Friday” blog series. In this series, I am...
2010-11-06
540 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