Ever have this conversation?
Dev: Hey, can you help me? The performance on my application is terrible all of a sudden.
DBA:...
2017-08-11 (first published: 2017-07-26)
3,197 reads
Over this week we’ve looked at the difference between Oracle and SQL Server from a few different angles. We’ve looked...
2017-08-11
1,098 reads
SQLskills is giving away free training for their performance tuning and optimization classes. My entry for the competition is below. If you decide to enter for yourself, entries are...
2017-08-11
8 reads
Welcome back, thanks for keep on reading me, and for the ones who read for the first time, welcome.With this third post I'll keep answering the question Where did...
2017-08-11
4 reads
Welcome back, thanks for keep on reading me, and for the ones who read for the first time, welcome.
With this...
2017-08-11
182 reads
One of the most talked about features previewed during the Microsoft Data Insights Summit in the previous June was the...
2017-08-11
1,256 reads
Well, that’s something to be proud of. This is my 500th post on this blog. Not including a handful of...
2017-08-10
416 reads
One of the problems that I’ve encountered since moving my Dev/QA departments to using SQL Server within containers is that...
2017-08-10 (first published: 2017-07-26)
2,488 reads
I’m a technical guy.
Thus – I love tools. They make stuff go.
Tools are great.
Except – as I wrote in my other post...
2017-08-10 (first published: 2017-07-26)
1,765 reads
Original help was identified from this article Why is VirtualBox only showing 32 bit guest versions on my 64 bit...
2017-08-10
131 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...
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