oPASS June 2010 Meeting Date Change
Normally we meet on the second Tuesday of the month, but in June we’re going to have to push the...
2010-05-19
567 reads
Normally we meet on the second Tuesday of the month, but in June we’re going to have to push the...
2010-05-19
567 reads
Last week I blogged about attending TechEd 2010 on a press pass, and since then I’ve been trying to come...
2010-05-19
560 reads
I’ve blogged on this before, here and here, and ended up chatting about it on Twitter (see, I do use...
2010-05-19
666 reads
You can choose from how query optimization works and why it’s so hard, or how relational engines and MapReduce can...
2010-05-19
656 reads
I struggled with the title for this one. One of the thoughts I had was that I believe in being...
2010-05-18
684 reads
On Thursday I presented ‘Building a Comprehensive Professional Development Plan’ to the PASS Professional Development Chapter (#PASSProfDev on Twitter) via...
2010-05-17
719 reads
A friend is moving into a leadership role for the first time and we talked some about making that transition....
2010-05-14
954 reads
Had this on my list todo list, upgrade my laptop that just had plain old SQL 2008 on it. The...
2010-05-13
616 reads
It’s been a couple years since I’ve attended and always found Teched to be a great event, more content than...
2010-05-12
1,225 reads
This was a phone meeting on April 8th, 2010, that covered:
Possibility of an online track at the 2010 PASS SummitDiscussion...
2010-05-11
691 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