SQL Server 2005 SP4
Last year I submitted a Connect item for SQL Server 2005 SP4. Quite a few people supported this item and...
2010-12-13
1,438 reads
Last year I submitted a Connect item for SQL Server 2005 SP4. Quite a few people supported this item and...
2010-12-13
1,438 reads
One piece of advice that is often given to new SQL Server administrators is not to shrink their databases. But they seem to do it often enough anyway. For this Friday's poll, Steve Jones asks if we should do away with shrink.
2010-12-10
986 reads
I hate not living up to commitments. It really, really bothers me and I have tried hard in my career...
2010-12-10
649 reads
I have been trying to figure out where to go in 2011 for SQL Saturdays, especially as Red Gate is...
2010-12-10
714 reads
Microsoft is working to certify vendors to build private clouds, which Steve Jones thinks is a great idea.
2010-12-09
173 reads
A look at what's happening with the SQLServerCentral servers based on the public information exposed by SQL Monitor.
2010-12-09
1,730 reads
Can you accurately determine the cost or benefit of a new, cool project up front? Steve Jones thinks not, but coming up with new projects can be a way to set yourself apart from others.
2010-12-08
115 reads
A repost from SQLServerCentral.
What would you like for Christmas?
Hint, hint, a little visual imagery of the kind of prize that...
2010-12-08
910 reads
Steve Jones found a very fascinating way that might keep elections more secure, verifiable, and also more open.
2010-12-07
109 reads
It’s time to wrap up T-SQL Tuesday for the year 2010 and I was invited to host his month’s blog...
2010-12-07
8,286 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