I travel, I work, I EAT
As most of you know I am a consultant with Pragmatic Works, which requires me to travel a bit. During...
2011-02-12
660 reads
Blog Posts
Presentation Slides For Hardware 201 at SQLSaturday #66 in Colorado Springs
I will be giving my Hardware 201: Selecting and Sizing Hardware for OLTP Performance presentation at SQLSaturday #66 at 1:30PM...
2011-02-12
860 reads
A NULL Is Not Unknown
Like it or not, NULLs happen. I don’t think that’s I’ve ever seen a production database that didn’t have NULLs. I’m not arguing whether or not NULLs in a...
2011-02-11
6 reads
A NULL Is Not Unknown
Like it or not, NULLs happen. I don’t think that’s I’ve ever seen a production database that didn’t have NULLs.
Waiter,...
2011-02-11
874 reads
Book Review: Packing for Mars
Packing for Mars by Mary Roach ($15 @ Amazon) is a ton of fairly interesting trivia about the space program, space...
2011-02-11
735 reads
Can You Dig It? – Find Estimated Cost
She can dig it!
D Sharon PruittIt’s the eighth post in the plan cache series. I hadn’t expect to take as...
2011-02-11
903 reads
Colorado Speaking Tour
Next week, I’ll be making a swing through central Colorado on a working vacation of sorts. I met up with...
2011-02-11
532 reads
Iowa PASS Presentation Materials
Driving to the User Group
This past Wednesday I took a drive down to the Iowa SQL Server Users Group meeting. ...
2011-02-11
480 reads
MDX Performance - burdens of IIF
I used to think naively that IIF is an innocent little function that can only do good and help me...
2011-02-11
3,093 reads
Pragmatically Yours Day 2 – Our Team
One of the things I’m most proud of at our company is our team.You can see some of our team...
2011-02-11
708 reads
Blogs
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...
Finally Cleaning Up Dropbox: Moving Almost a TB to Google Drive with rclone
By davebem
I’ve had a Dropbox account for years. Like a lot of people, I started...
Forums
BCA KCP Pasar Minggu Center | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Jl. Lenteng Agung Raya No.26 E-F, RT.1/RW.4, Ps. Minggu, Kota Jakarta Selatan, Daerah...
BCA KCP Gatot Subroto | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Centennial Tower, Jl. Gatot Subroto No.Kav 24-25 lantai GF unit C, RT.2/RW.2, Karet...
BCA KCU BLOK A CIPETE | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Jl. RS. Fatmawati Raya No.6 A, RT.1/RW.5, Cipete Sel., Kec. Cilandak, Kota Jakarta...
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