(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2019-07-01 (first published: 2019-06-18)
1,620 reads
In general this homework series is meant to give you ideas of things to play with that most if not ... Continue reading
2019-07-01
135 reads
Being MVP for the #11 straight year is something unique! Thank you! The first week of July has just started. So oficially we have started vacations and the team...
2019-07-01
17 reads
Thanks for joining us at #SQLSatPensacola!The 8:30am Careers in Technology panel featured lots of talk about Twitter, so might as well mention that the panelists were (in audience's order,...
2019-06-30
9 reads
This is actually part 2 of a process I am creating to automatically discover SQL Server instances in an Active Directory domain. So there will be a series of...
2019-06-28
7,579 reads
This month’s T-SQL Tuesday blog is brought to us by Mohammd Dorab (b | t) and this month topic is about what you would tell your 20-year-old self now...
2019-06-28 (first published: 2019-06-11)
304 reads
There’s a lot that goes on in June. From the 75th anniversary of D-Day, Fathers Day, to the official start of summer (though it feels like it already!)....
2019-06-28 (first published: 2019-06-11)
232 reads
With this script, I have the ability to quick show which step is failing, what the command is for that step, what kind of process is running on that...
2019-06-27
80 reads
With this script, I have the ability to quick show which step is failing, what the command is for that step, what kind of process is running on that...
2019-06-27
5 reads
First, some blah... blah... blah...
By default when a primary key constrained is created on a table/view, SQL Server automatically creates a unique clustered in order to enforce it. And...
2019-06-27
74 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...
WhatsApp:0818-751-777 Gedung Gajah Tebet, Jl. Dr. Saharjo No.Raya 111 Unit N & O, RT.1/RW.1,...
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...
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