Is CPU-Z Risky To Run on a Production Server?
There was a conversation on Twitter recently (with the #sqlhelp hashtag) about whether it was completely safe to run the...
2011-02-19
1,783 reads
SQL Saturday #70 - Columbia, SC 2011 Session Schedule Is Up!
As announced, we have posted our session schedule for SQL Saturday #70 - Columbia, SC. The event will be March 19, 2011...
2011-02-19
1,272 reads
What Should PASS Be? I Challenge You
PASS isn’t what it should be. I hear that a lot, and in many ways I agree with you. We’re...
2011-02-18
556 reads
Notes from the February 2011 MagicPASS Meeting
I attended the second meeting of MagicPASS (no web site yet) on Feb 16 at Stetson University in Celebration, FL....
2011-02-18
555 reads
PowerPointShell
I wanted to add a neat demo to my .NET Powers Activate! Form of PowerShell! presentation that would really demonstrate...
2011-02-18
545 reads
The Importance Of Managing Expectations
Have you ever taken a sip of sweet tea only to discover that it was soda instead? Eeww! What an eye-opening experience! Don’t misunderstand; I like soda. But when...
2011-02-18
13 reads
The Importance Of Managing Expectations
Have you ever taken a sip of sweet tea only to discover that it was soda instead? Eeww! What an...
2011-02-18
653 reads
Renumbering Rows in a Table Variable (or Table/Temp Table)
I was recently working on a data cleanup problem where I had to do lots of comparisons of one row...
2011-02-18
4,323 reads
SSWUG Free SSIS Expo – Today!
SSWUG Free Expo Event: Basic and Complex SSIS Features virtual conference is today! There’s a chance that you can probably...
2011-02-18
692 reads
Intro to SSAS BI Workshop - Review
A Synopsis of My Experiences of the “Intro to SSAS” BI Workshop in NYC!
By Robert Pearl
Well it’s a wrap of...
2011-02-18
1,845 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