SQL University - Capacity Planning Week
I am honored to be a guest lecturer this week for SQL University. There have been some amazing professors helping...
2010-07-26
8,163 reads
I am honored to be a guest lecturer this week for SQL University. There have been some amazing professors helping...
2010-07-26
8,163 reads
It's important to have time to think, but quite often we don't find the time. Steve Jones comments on how he's learned just how valuable this can be.
2010-07-26
352 reads
ROWE stands for a Results Oriented Work Environment. This Friday Steve Jones asks if you'd like to work in one.
2010-07-23
180 reads
One of the new products that Red Gate Software has released recently is SQL Source Control. I saw a demo...
2010-07-23
1,481 reads
I have a few people ask about this recently, so I thought I’d blog about it, and maybe get an...
2010-07-23
1,000 reads
2010-07-23
2,620 reads
Is self service BI a good idea? Some people think so, others don't. Steve Jones talks about one of the issues and why it might actually not be a problem.
2010-07-22
380 reads
The hardest thing, I think, for most new organizers of a SQL Saturday is the fundraising. A few years ago...
2010-07-22
1,098 reads
I keep seeing lots of debate about Android v the iPhone 4. I have friends talking about how cool Windows...
2010-07-21
1,172 reads
One thing I learned years ago in C programming was the elegance of using operators and simplifying expressions. This sometimes...
2010-07-21
736 reads
By gbargsley
One of the first things I review when I inherit a new SQL Server...
By Arun Sirpal
It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...
By davebem
I’ve had a Dropbox account for years. Like a lot of people, I started...
WhatsApp:0818-751-777 Gedung Gajah Tebet, Jl. Dr. Saharjo No.Raya 111 Unit N & O, RT.1/RW.1,...
When things go wrong - like trouble signing in, videos pausing, unclear charges, or...
Tlp/Wa_Cs:0817-866-887. Jl. Lenteng Agung Raya No.26 E-F, RT.1/RW.4, Ps. Minggu, Kota Jakarta Selatan, Daerah...
I have a SQL Server 2022 English default installation on a server. I want to detect if there are any upper case characters in rows and I have this code:
SELECT CustomerNameID,
CustomerName
FROM dbo.CustomerName
WHERE CustomerName = LOWER(CustomerName)
Here is the sample data I am testing with:
CustomerNameID CustomerName 1 John Smith 2 Sarah Johnson 3 MICHAEL WILLIAMS 4 JENNIFER BROWN 5 david jones 6 emily davis 7 Robert Miller 8 LISA WILSON 9 christopher moore 10 Amanda TaylorHow many rows are returned? See possible answers