Presenting at SQLSaturday #16
I’ll be attending SQLSaturday #16 in South Florida on August 8th and doing two presentations, one on statistics and one...
2009-07-13
331 reads
I’ll be attending SQLSaturday #16 in South Florida on August 8th and doing two presentations, one on statistics and one...
2009-07-13
331 reads
I finished up reading Traffic: Why We Drive the Way We Do by Tom Vanderbilt last week and enjoyed it....
2009-07-10
375 reads
Part 2 of MVP Andy Warren's SQL School video on Instead of Triggers.
2009-07-09
5,254 reads
I was having a discussion with Brian Knight yesterday about whitepapers and thought I’d share some of it – from my...
2009-07-09
436 reads
If you haven’t seen the news yet we’ve got something new on the schedule this year – a 2 hour seminar...
2009-07-08
570 reads
If you have never used an instead of trigger, it's a great mechanism for evading table triggers in certain situations. MVP Andy Warren brings you part one of this SQL School video.
2009-07-07
7,526 reads
Russ Fustino from Microsoft just sent me the link to episode #3 that was filmed at SQLSaturday #14 in Pensacola....
2009-07-06
485 reads
Since the beginning of SQLSaturday I’ve covered most of the news here on my blog, beginning this week I’ll be...
2009-07-06
464 reads
Read the Declaration of Independence and then it’s time for fireworks and grilling, maybe some apple pie too!
2009-07-03
504 reads
Rolling Thunder ($7.99 @ Amazon) by John Varley is the third book in the series. I previously reviewed Red Thunder and...
2009-07-02
710 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...
I have an issue where I have a Bill of Material list of items...
Comments posted to this topic are about the item Follow Your Hunch
Comments posted to this topic are about the item What Happens When You Ask...
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