Clean Code is Easier to Read – SQL Prompt
I saw a post recently that had query that looked like this:
select a.*,name, b.*
from sys.database_principals a, sys.database_permissions b
where permission_name...
2011-05-12
1,834 reads
You Are Responsible for You
Steve Jones wrote an editorial yesterday called The Poor Soul. It talked about being thrown into a responsibility one didn't...
2011-05-12
748 reads
Locking While Dropping or Altering an Index
Yesterday I was trying to drop some hypothetical indexes in production against a fairly active table. I started causing blocking...
2011-05-12
7,559 reads
Pragmatic Tools Week: Task Factory
If you've ever spent any time doing SSIS development work, you'll eventually come to a point when developing something and...
2011-05-11
1,440 reads
DBA VC Presentation May 11
Come one, come all!! Oh wait, it’s too late now. I just finished giving my presentation to the DBA VC (virtual chapter). There was good attendance and there were...
2011-05-11
5 reads
DBA VC Presentation May 11
Come one, come all!! Oh wait, it’s too late now. I just finished giving my presentation to the DBA VC...
2011-05-11
667 reads
T-SQL: Identifying, inserting and removing spaces in strings
Frequently, when working with strings you will need to identify, insert or remove spaces before, after or in between characters.
For example, you may...
2011-05-11
3,805 reads
Troubleshooting Performance -1
Whenever you get a call from user that they are facing any performance issue what would you do. As I...
2011-05-11
476 reads
Patch Week
My email account started getting notices of Windows patches yesterday, indicating it’s patch week again. If you manage Windows devices,...
2011-05-11
897 reads
Networking and Connections
This quote says it all:
It’s from an article on the 9/11 memorial and how an algorithm was used to inscribe...
2011-05-11
752 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