Jacksonville Code Camp Call for Speakers
Bayer White has announced the call for speakers for the 2010 Jacksonville Code Camp to be held August 28, 2010...
2010-06-14
312 reads
Bayer White has announced the call for speakers for the 2010 Jacksonville Code Camp to be held August 28, 2010...
2010-06-14
312 reads
In previous years we’ve just invited a speaker or two to submit a presentation for an all day paid event...
2010-06-14
371 reads
I wrote this editorial about bad design based on some real world experiences. It’s a fun story, maybe even borderline...
2010-06-14
377 reads
A guest editorial from Andy Warren looks at a bad database design he recently ran across.
2010-06-11
1,303 reads
I had a chance to watch a few different styles this week at TechEd, and I think it helped that...
2010-06-11
629 reads
This editorial for the SSC newsletter ran last week and talks about the conundrum for software vendors – how do you...
2010-06-10
599 reads
My final day at TechEd. Packed up and checked my bag at the hotel, off to the bus. Noticed that...
2010-06-10
340 reads
Noticed that they have ‘overflow’ rooms where they are broadcasting sessions that max out attendance, very nice. Wonder how much...
2010-06-09
629 reads
Herain Oberoi is a Group Product Manager for SQL Server and spent 30 minutes with me talking about StreamInsight and...
2010-06-08
553 reads
After the keynote went back to the press room to write up notes (which I posted already), check email, eat...
2010-06-08
491 reads
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
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...
I have an issue where I have a Bill of Material list of items...
Comments posted to this topic are about the item Follow Your Hunch
Comments posted to this topic are about the item What Happens When You Ask...
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