PASS Election Voting Has Started
You should get an email if you’re eligible to vote with a subject line beginning with ‘Vote for the 2010/2011...
2009-10-14
288 reads
You should get an email if you’re eligible to vote with a subject line beginning with ‘Vote for the 2010/2011...
2009-10-14
288 reads
One of the things on my todo list for this past week was to upgrade a SQL 2005 Standard Instance...
2009-10-13
745 reads
Ever had a day when a bunch of small things run together to create a day you wish you had...
2009-10-12
326 reads
See his quiet post about it here. This comes right after finishing up his first book titled Protecting SQL Server...
2009-10-12
283 reads
We just had our October board meeting, this one ran the full hour and was a good discussion, catching up...
2009-10-12
230 reads
I try to be balanced on new technology and ideas, trying to find the middle ground between hype and usefulness,...
2009-10-11
390 reads
Yesterday was a typical Florida afternoon, sudden down pour of rain, but not a storm. Just slow solid rain for...
2009-10-08
330 reads
If you’re attending the PASS Summit this year I hope you’ve decided to attend the two hour Networking to Build...
2009-10-08
572 reads
Not very often I run across something with zero matches in a search engine, but had it happen recently. I...
2009-10-07
358 reads
I’ve been working on an idea for a while with Brent Ozar and Jeremiah Peschka for a contest that recognize...
2009-10-06
1,596 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