SQLSaturday Schedule Changes
As will happen from time to time, we’ve had two changes on the schedule, wanted to make sure everyone catches...
2010-06-21
486 reads
As will happen from time to time, we’ve had two changes on the schedule, wanted to make sure everyone catches...
2010-06-21
486 reads
Yesterday I wrote about deciding to build a quick and dirty voting solution. Or to try to at least! Should...
2010-06-18
750 reads
The minutes of the June 2010 Board meeting have been posted and if you haven’t read them yet, you missed...
2010-06-18
670 reads
Last year for the annual Board of Directors election we used Zoomerang as our e-voting solution. It’s not the worst...
2010-06-17
516 reads
We had adjusted our meeting date to work around previous commitments for both Jack Corbett and I, and that may...
2010-06-17
544 reads
It’s been almost a month since my last update, too long! I’ve put up separate posts on my unplanned and...
2010-06-17
703 reads
Today we have a guest editorial from Andy Warren that looks at the value of experience.
2010-06-17
212 reads
Our most recent 24 Hours of PASS celebrated the SQL 2008 R2 launch. 24 great sessions, 23 of which were...
2010-06-16
586 reads
As the owner of a meeting/discussion you have two options on how to drive the conversation, and which you use...
2010-06-16
381 reads
We’re meeting from 6-8 pm as usual, with Kendal Van Dyke presenting Paging Dr Availability, You’re Wanted In the Recovery...
2010-06-15
312 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