Networking Sins
I ran across this article about networking sins a while back and have had it on my list to share....
2009-09-15
1,365 reads
I ran across this article about networking sins a while back and have had it on my list to share....
2009-09-15
1,365 reads
In the next week or so I’ll be upgrading the SQL 2005 server that has the SQLSaturday database and I’m...
2009-09-14
1,584 reads
Through tomorrow you can register for the very discounted rate of $1395 – details at http://summit2009.sqlpass.org. Historically we see a surge...
2009-09-14
633 reads
We’ve got a great meeting coming up with Todd Holmes doing a mini presentation on Backup Basics, followed by Jorge...
2009-09-13
237 reads
I’ve been on the board just about 8-1/2 months, so I’m not doing too bad on updates, but think I’ll...
2009-09-13
947 reads
I glance at Make (magazine and web site) from time to time, and recently have been recording and watching their...
2009-09-10
808 reads
My friend Don Gabor is providing us with some tips on networking as related to both PASS and the PASS...
2009-09-10
222 reads
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-09-10
845 reads
I taught myself programming with Quick Basic (started with Turbo Basic but couldn’t find a book on it, so bought...
2009-09-09
370 reads
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-09-08
715 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