More info on nested views causing performance problems
As if I needed any further convincing that nested views were bad....
The other day I had to write a particularly...
2011-02-15
1,188 reads
Are int joins faster than string joins?
This one comes up a lot on the forums, often as advice given…
“You should use integers for the key rather...
2011-02-15
5,504 reads
Presenting "Secrets Of SQL Server" Idera Webcast On Feb. 16
On Wednesday, Feb 16th, 3 PM Eastern I'm presenting a webcast for Idera's Secrets of SQL Server series. Presentation details...
2011-02-15
718 reads
UN-SQL Friday #003–Vendor Love
The love that dare not speak it’s name… Yes, love for vendors. <shudder> Oh, I mean I love my new...
2011-02-15
594 reads
SQL Saturday #60, Cleveland Speaker Evals
I just received 35 speaker evaluations from SQL Saturday #60 in Cleveland. It was a great event (although I had...
2011-02-15
1,018 reads
Recent AMD Processor News
AMD has released five new specific models in their Opteron 6100 series line. Of these, the one you should be...
2011-02-15
468 reads
February Update
I haven't written anything for a while and again, for the second month running I missed TSQL2usday. It's a shame...
2011-02-15
487 reads
Redgate’s Free SQL Search Tool
I have been using this tool for quite a while and just remembered that I haven’t written a blog about...
2011-02-15
2,137 reads
The DBA Ultimate Fitness Workout Plan
If you plan to stay on top of your DBA game then you have to workout regularly.
Those of you that...
2011-02-15
732 reads
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
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