Results of PASS Summit 2010 Content Survey Released
A few weeks back PASS sent out a survey to get input on how to shape the 2010 Summit agenda,...
2010-04-22
537 reads
A few weeks back PASS sent out a survey to get input on how to shape the 2010 Summit agenda,...
2010-04-22
537 reads
Most of us have some general rules we live by, and I’ve often thought it would be a lot easier...
2010-04-21
727 reads
We just put the site up, starting a little earlier than last year, and over the course of this week...
2010-04-21
499 reads
Found Ninite while browsing a list of efficiency tools on PCWorld.com. It’s a one stop super installer, you run through...
2010-04-20
627 reads
I’ve had this on my list to write about for a while, just didn’t have a great example until this...
2010-04-19
498 reads
I hear that registration is over 350 so far, with seats still available – but register soon! I’m driving up with...
2010-04-19
507 reads
First, some background. If you’ve been to the Summit you know that we have an opening night reception, lots of...
2010-04-16
1,119 reads
A few weeks back I was in Chicago for three days for work. I’ve been through the airport a couple...
2010-04-16
954 reads
I’ve been waiting on this for a while, and missed the announcement that it was available, happened to see that...
2010-04-15
546 reads
SQLSaturday #38 is coming up on May 8th, 2010, back at the same location as in previous years at the...
2010-04-15
492 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