Why Would They Coach Me?
During a recent call I was talking with someone about achieving a career goal (coaching in itself, though unplanned) and...
2010-07-08
765 reads
During a recent call I was talking with someone about achieving a career goal (coaching in itself, though unplanned) and...
2010-07-08
765 reads
A guest editorial from Andy Warren. Experience helps us do a better job, and one way you can get that is learning from experts.
2010-07-07
253 reads
This is one of the lessons you don’t want to hear when you’re 18, or the newest member of a...
2010-07-07
293 reads
Another story with a lesson today, this one about learning to work smarter and not just harder. Easy to say,...
2010-07-07
256 reads
Here’s another quirk that has been there forever. Open up the linked table UI and select a handful of tables,...
2010-07-06
304 reads
I think all managers are told they must delegate to succeed and/or survive. Seems obvious, a manager can’t do it...
2010-07-01
323 reads
I use Access when I don’t have dedicated admin tools for editing data, frequently the case for infrequently changed data...
2010-06-30
3,146 reads
Conference calls are a fact of life for most of us. Remote offices, remote workers, clients – lots of reasons to...
2010-06-29
1,426 reads
A simple motivational plan goes sideways in this guest editorial from Andy Warren.
2010-06-29
200 reads
Here’s the editorial for SSC today and while it’s a humorous story about asking for donuts and getting a free...
2010-06-29
1,426 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