Recent AMD Processor News
AMD has released five new specific models in their Opteron 6100 series line. Of these, the one you should be...
2011-02-15
467 reads
AMD has released five new specific models in their Opteron 6100 series line. Of these, the one you should be...
2011-02-15
467 reads
I have been using this tool for quite a while and just remembered that I haven’t written a blog about...
2011-02-15
2,136 reads
I just received 35 speaker evaluations from SQL Saturday #60 in Cleveland. It was a great event (although I had...
2011-02-15
1,016 reads
If you plan to stay on top of your DBA game then you have to workout regularly.
Those of you that...
2011-02-15
728 reads
The love that dare not speak it’s name… Yes, love for vendors. <shudder> Oh, I mean I love my new...
2011-02-15
593 reads
Much like the USA Network here in the States welcomes characters, I’d like to formally let the world know that...
2011-02-14
575 reads
I see this question on the forums all the time and thought it was worth a repost here.
Just this week,...
2011-02-14
1,325 reads
Do you know about congenital heard defects (CHD)? Did you know that February 7-14 is the week dedicated to making...
2011-02-14
471 reads
PASSMN meeting is this week on Tuesday. Without further ado…
Meeting Details
Here are the details on the meeting location and time:
Date:February...
2011-02-14
528 reads
On Wednesday, February 16 at 2:00pm CST I’ll be presenting “.NET Powers Activate! Form of PowerShell!” to the PASS PowerShell...
2011-02-14
778 reads
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...
By davebem
I’ve had a Dropbox account for years. Like a lot of people, I started...
When things go wrong - like trouble signing in, videos pausing, unclear charges, or...
Tlp/Wa_Cs:0817-866-887. Jl. Lenteng Agung Raya No.26 E-F, RT.1/RW.4, Ps. Minggu, Kota Jakarta Selatan, Daerah...
Tlp/Wa_Cs:0817-866-887. Centennial Tower, Jl. Gatot Subroto No.Kav 24-25 lantai GF unit C, RT.2/RW.2, Karet...
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