T-SQL Tuesday #024: Prox ‘n’ Funx
I find myself just now sitting down to write this as the deadline for TSQL Tuesday 24 fast approaches. Fortunately...
2011-11-08
662 reads
Jason Brimhall
T-SQL Tuesday #024: Prox ‘n’ Funx
Functions are very handy. They can also prove to be the cause of poor performance (such as was the case with that string splitter). When used appropriately, you can...
2011-11-08
5 reads
SSSOLV November 2011 Meeting
Another month, another meeting. Time really is flying. And now with more Holidays fast approaching, I am sure that time...
2011-11-07
576 reads
SSSOLV November 2011 Meeting
Another month, another meeting. Time really is flying. And now with more Holidays fast approaching, I am sure that time will warp on us. The Las Vegas user group...
2011-11-07
4 reads
We are Family
It has been a while since I last wrote something for a meme monday. This month is a perfect time...
2011-11-07
676 reads
We are Family
It has been a while since I last wrote something for a meme monday. This month is a perfect time to jump back in the deep end. If you...
2011-11-07
4 reads
Another Color Wheel
Some time ago, I had the opportunity to work on a problem involving the color wheel. The requirements for that...
2011-11-03
1,265 reads
Another Color Wheel
Some time ago, I had the opportunity to work on a problem involving the color wheel. The requirements for that problem lent themselves to a solution involving bitwise operations...
2011-11-03
5 reads
Quick and Dirty Index Info
From time to time, somebody needs to find some information about the indexes in the database. As DBA’s, there are...
2011-11-01
738 reads
Quick and Dirty Index Info
From time to time, somebody needs to find some information about the indexes in the database. As DBA’s, there are a few tools at your disposal to look up...
2011-11-01
12 reads
Blogs
No Shortcuts for the SQLCMD Batch Terminator: #SQLNewBlogger
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
Where Is My SQL Agent? Running Scheduled Jobs Against Azure SQL Database
By gbargsley
One of the first things I review when I inherit a new SQL Server...
AgentDBA vs Critical SQL Server
By Arun Sirpal
It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...
Forums
ALAMAT BCA KCU HR MUHAMMAD TLP/WA 0817839777
Bantuan Cs 0817839777 Jl. Mayjen HR. Muhammad No.17, Putat Gede, Kec. Sukomanunggal, Surabaya, Jawa...
BCA KCU BUKIT DARMO BOULEVARD Tlp:0817839777
Telp / Wa 0817839777 Jl. Mayjend. Jonosewojo No.14, Pradahkalikendal, Kec. Dukuhpakis, Surabaya, Jawa Timur...
ALAMAT KANTOR BCA KCU SIDOARJO TLP/WA 0817839777
Cs: 0817839777 Jl. Ahmad Yani No.39 A, Rw1, Sidokumpul, Kec. Sidoarjo, Kabupaten Sidoarjo, Jawa...
Question of the Day
Detecting Characters
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