Making Choices Narrows Your Remaining Options
I’ve had variations of this conversation a couple of times lately and thought it was worth writing down some thoughts....
2010-07-15
510 reads
I’ve had variations of this conversation a couple of times lately and thought it was worth writing down some thoughts....
2010-07-15
510 reads
Short notes this time, but wanted to get a few thing written down:
Attendance was about 20, lower than expected for...
2010-07-14
474 reads
We’ve got 6 days left before the call for nominations for the 2010 PASS election closes and I want to...
2010-07-14
857 reads
Here’s another one that I’ve run into when linking to a SQL Server table that has a bit column. Maybe...
2010-07-13
332 reads
Our regular monthly meeting is tonight featuring David Pless from Microsoft. Here are some notes about his presentation:
This discussion will...
2010-07-13
231 reads
Our regular monthly meeting is tonight featuring David Pless from Microsoft. Here are some notes about his presentation:
This discussion will...
2010-07-13
216 reads
As a child did you have a place that was your ‘thing’, something that just the mention of it would...
2010-07-12
509 reads
Excited to get the email yesterday that two of my sessions were accepted, Introduction to SQL Server Statistics and Building...
2010-07-09
412 reads
We had our monthly Board of Directors call on July 8th and as is fairly common, the call went smooth....
2010-07-09
1,153 reads
We’re pleased to announce that Louis Davidson will be our pre-con speaker this year at SQLSaturday #49 in Orlando. Louis...
2010-07-09
221 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