PASS Update #18
Eric Wisdahl posted some questions on my last update, and I thought I’d reply here to make my answers more...
2009-10-27
1,051 reads
Eric Wisdahl posted some questions on my last update, and I thought I’d reply here to make my answers more...
2009-10-27
1,051 reads
Funny how tools can surprise you. I’ve had in mind to set up a sub-group and invite all the SQLSaturday...
2009-10-26
603 reads
I posted some thoughts on business cards awhile back, had used up the ones I had and was time to...
2009-10-25
682 reads
I presented Social and Not So Social Networking for the DBA. Of the attendees, 16 submitted an eval. Here are...
2009-10-25
555 reads
I ordered the ' target=_blank>The Board Book from Amazon ($18) to try to get some ideas for how to do a...
2009-10-22
585 reads
I thought I’d finish up the notes by listing things that went well and not so well:
Jack Corbett really helped...
2009-10-22
539 reads
I’ve been wanting to write this for a while, but have been waiting for the board elections to close. Lots...
2009-10-22
843 reads
Eric Wisdahl posted some questions on my last update, and I thought I’d reply here to make my answers more...
2009-10-22
798 reads
Just released on the PASS site is that news that Tom Larock, Jeremiah Peschka, and Brian Moran are the new...
2009-10-21
624 reads
Picking up from yesterday, once we got through the confusion of the room changes everything settled down. I checked the...
2009-10-21
615 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