PASS Summit Magic: The Turn
Watch closely...
I mentioned in my last post that the Turn is the point in the act where the magician executes...
2010-11-15
1,483 reads
SSIS Denali Resolve References
One of the new features in SSIS Denali that I’m really excited about (Other than the ability to Undo ctrl-z)...
2010-11-15
1,412 reads
Presenting At East Iowa SQL Server Users Group On Nov. 16
On Tuesday, November 16, I'll be presenting Paging DR Availability, You're Wanted in the Recovery Room via LiveMeeting to the...
2010-11-15
515 reads
SQLServerPedia Awards Winner
Thanks to all those that voted for my Index Black Ops blog series for the SQLServerPedia blog awards. I am...
2010-11-15
559 reads
PASS Summit 2010-Wrap Up
Thursday ended with a ‘Meet the Board’ meeting where attendees could come ask the Board questions or present ideas. It...
2010-11-15
736 reads
David Dewitt at the PASS Summit
The PASS Summit is complete and we got what we asked for from David Dewitt. He spoke on the third...
2010-11-15
2,094 reads
Switching Off Parameter Sniffing
Or, another way to put it, in most cases, shooting yourself in the foot.
I was not aware that the cumulative...
2010-11-15
2,895 reads
PASS, Keynotes and Tweeting
I have never had the opportunity to go to PASS before, but even though I was unable to attend this...
2010-11-15
334 reads
The PowerShell CookBook
“A script club.” That’s what a friend of mine said when he was telling me how he’d learned the basics...
2010-11-15
451 reads
It's an Opportunity! Not an Obstacle!
Write this down… No really… Write it, print it, send it to all of your friends and loved ones. J...
2010-11-15
382 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