What’s Going on with SQL Server Service Account Changes?
For years we’ve been told you should use Enterprise Manager in SQL Server 2000 or SQL Server Configuration Manager in...
2010-12-10
2,259 reads
Can You Dig It? – Parallelism in the Plan Cache
She can dig it!
D Sharon PruittIn the lead in to this post, I talked about how the plan cache can...
2010-12-09
6,253 reads
Book Review: The Way We Work Isn’t Working
The Way We Work Isn’t Working by Tony Schwartz ($19 @ Amazon) is a holistic approach to work and a work...
2010-12-09
603 reads
SQL Saturday New England, #71
I’ve finally got everything together to get the web site going for SQL Saturday #71. The call for speakers is...
2010-12-09
593 reads
Spotlight: Jes Borland
It’s been a few months…time for another Spotlight!
Just to catch you up, occasionally someone in the SQL community – usually someone...
2010-12-09
1,417 reads
Microsoft Codename Atlanta Attempts to Help Out DBAs By Providing Basic Assistance
I have always recommended that DBAs be as proactive as possible, catching potential problems, and actual problems, as soon as...
2010-12-09
1,100 reads
SQL Server 2008 R2 System Views Map
Update from Microsoft for SQL Server 2008 & 2008 R2. There is the graphical map of the system views included SQL...
2010-12-09
1,040 reads
Bundle of Joy
After baking for 9 months, our bouncing baby girl has finally arrived. She arrived Thursday Dec 2, 2010 at 8:28 AM (PST). There were no complications and the delivery...
2010-12-09
3 reads
Bundle of Joy
After baking for 9 months, our bouncing baby girl has finally arrived. She arrived Thursday Dec 2, 2010 at 8:28...
2010-12-09
631 reads
December 2010 SSSOLV Reminder
Here is a quick reminder and a repost of the announcement from last week. This month we will be broadcasting the meeting once again. This month the technology bug...
2010-12-08
6 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