Join the PASS Summit 2010 Program Committee
Just in case you didn’t see it, we’re looking for volunteers for the 2010 program committee – the team that evaluates...
2010-02-17
754 reads
Just in case you didn’t see it, we’re looking for volunteers for the 2010 program committee – the team that evaluates...
2010-02-17
754 reads
I wrote an editorial for SSC back on January 19th about the perfect being the enemy of the good. It’s...
2010-02-17
507 reads
Yesterday I had the Adversity Index, today it’s the Power Grid from MediaIte. It attempts to score the power of...
2010-02-17
748 reads
Live Writer tends to be one of those applications that you spend a few minutes configuring and then you forget...
2010-02-16
580 reads
Recently I was just killing a few minutes and was looking for some tips for Windows 7. I get along...
2010-02-15
611 reads
I heard the news via a blog post by Ward Pond that one of my favorite authors had died at...
2010-02-12
1,731 reads
In a nutshell, I’m interested in growing and diversifying the pool of speakers that focus on SQL Server. You might...
2010-02-11
989 reads
Really rainy in Orlando today, traffic is horrible. We had a higher than usual number of RSVP’s for the meeting,...
2010-02-10
478 reads
Greg Larsen is hosting SQLSaturday in Redmond, WA again this year, this time on June 12, 2009. Call for speakers...
2010-02-10
588 reads
In our world sometimes it’s worth the time and effort for in depth tuning to get the machine to run...
2010-02-10
794 reads
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
A good week ago I hosted the monthly T-SQL Tuesday blog party. I invited...
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
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