The results are in: What Tech Companies Are Doing it Right?
Last week I asked you: What Tech Companies Are Doing it Right?
Which SQL (or SQL-adjacent) tech companies are doing right,...
2011-02-14
881 reads
SQL Server and the “Lock pages in memory” Right in Windows Server
Another Windows setting you might want to enable is “Lock pages in memory”. There is some controversy within the SQL...
2011-02-14
1,724 reads
BIxPress 3.0: DBAs Welcome!
Much like the USA Network here in the States welcomes characters, I’d like to formally let the world know that...
2011-02-14
578 reads
Writing A Month Long Blog Series
You might wake up one day soon and think, “Hey, wouldn’t it be cool to write a month long blog...
2011-02-14
612 reads
Presenting for the PASS PowerShell Virtual Chapter
On Wednesday, February 16 at 2:00pm CST I’ll be presenting “.NET Powers Activate! Form of PowerShell!” to the PASS PowerShell...
2011-02-14
783 reads
Quest Webcast: Dos and Don’ts of Database corruption
I was guest presenter on last week’s Quest Pain of the Week presentation. The presentation is available for download from...
2011-02-14
650 reads
Working on the Railroad
I work with a client that has an office about 25 yards from a train track and recently the railroad...
2011-02-14
609 reads
Can I Add Controls to a Reporting Services Report?
I see this question on the forums all the time and thought it was worth a repost here.
Just this week,...
2011-02-14
1,329 reads
CHD Awareness Week
Do you know about congenital heard defects (CHD)? Did you know that February 7-14 is the week dedicated to making...
2011-02-14
474 reads
February PASSMN Meeting This Week
PASSMN meeting is this week on Tuesday. Without further ado…
Meeting Details
Here are the details on the meeting location and time:
Date:February...
2011-02-14
531 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