Outlook Productivity Tricks
I have a love/hate relationship with Outlook. It's the required email client at work and because it interfaces with so...
2011-05-05
2,109 reads
Policy-Based Management and Local Password Policy
This post is based on an interesting question/situation that was posted over at ASKSSC.com today. The user asked how to...
2011-05-04
1,402 reads
Designing Reports with Custom MDX Queries – part 2
…continued from part 1:
Building a Report
For the remainder of this article, I will demonstrate query and report design techniques by...
2011-05-04
1,679 reads
Designing Reports with Custom MDX Queries – part 3
Start at part 1
…continued from part 2:
Handling Parameters
When an MDX query is created using the graphic query designer, parameters can...
2011-05-04
1,218 reads
PASS 2011 Summit Abstract Submissions
Today is the last day to submit session abstracts for the PASS 2011 Summit. I was lucky enough to speak...
2011-05-04
478 reads
SQLRally 2011 Scripting Guy Guest Blog Post
Ed Wilson (Blog|Twitter) aka Scripting Guy has series of SQL Server related posts the week of May 2nd 2011 including...
2011-05-04
833 reads
SSIS package runs fine until put in a job
I see this issue pop up every now and then: A developer creates an SSIS package in BIDS and gets...
2011-05-04
795 reads
SQLRally–Don’t Forget Your Business Cards?
SQLRally is a week away. Are you ready? It’s going to be a good time to learn and freshen up...
2011-05-04
491 reads
Meme Monday: I Got 99 SQL Problems And the Disk Ain’t One
Advertisements
Meme Monday: I Got 99 SQL Problems and the Disk Ain’t One
I am a bit late to this party. I have seen...
2011-05-04
470 reads
SQL Saturday #74 Session Recap
Hopefully if you came to my session this year at SQL Saturday in Jacksonville, FL you came away with some...
2011-05-04
515 reads
Blogs
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
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...
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