Customer Loyalty Cards, Convenience, and Privacy
I bet most of you have at least one customer loyalty card in your wallet or on your keyring, one...
2009-07-20
726 reads
I bet most of you have at least one customer loyalty card in your wallet or on your keyring, one...
2009-07-20
726 reads
I read a nice article by Steve M List called Think Before You Speak in MSDN Magazine and it talks...
2009-07-19
502 reads
I finished reading Fault Line by Barry Eisler ($16.50 @ Amazon) a few weeks ago. I’ve been a fan for a...
2009-07-17
600 reads
This edition of SQL School brings us a look at how to set single user mode for your SQL Server instance.
2009-07-16
4,201 reads
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-07-15
426 reads
Saw an announcement in Eweek about this, so went looking and found this review of the Imation SSD Upgrade Kit....
2009-07-15
566 reads
Database Mail is an essential part of administering SQL Server for most people. MVP Andy Warren brings us part 2 of how to set up this subsystem.
2009-07-14
6,346 reads
I ran across this post about time to move beyond 960 where it talks about most websites today are designed...
2009-07-14
371 reads
Chad Miller will be doing a presentation on Powershell and we’ll have our usually round table discussion afterward – often the...
2009-07-14
467 reads
Cross posted from the SQLSaturday blog
Though few see it, we also maintain a full set of admin tools for the...
2009-07-14
538 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