Red Pyramid
After having read the Percy Jackson series of books, I wanted to read a few more books by Rick Riordan....
2010-10-02
476 reads
Jason Brimhall
SQLSat 54
Wow, I have really been kinda slow in the blog department for a couple of weeks now. I have a...
2010-10-01
592 reads
TSQL Tuesday Indexes and Blobs
Woohoo – chugga chugga chugga chugga – woo woo. The train is pulling into town once again for another installment in the...
2010-09-15
1,751 reads
September S3OLV
Here is another short reminder about this months UG meeting in Las Vegas.
We will be meeting Thursday at the same...
2010-09-08
499 reads
September TSQL Tuesday
It is hard to believe that time is flying like it is. Already it has been a month since I...
2010-09-08
523 reads
Managing Contacts
This is one of those posts that has little to do with SQL Server and more to do with helping...
2010-09-06
561 reads
September S3OLV Meeting
Another month has crept up upon us. It is time once again for the Las Vegas User Group /PASS Chapter...
2010-09-03
493 reads
SQLSaturday SLC 2010
Well, I have taken another plunge. I finally got around to submitting a session for SQL Saturday Salt Lake City...
2010-09-01
517 reads
Defensive Db Programming Chapter 06
We are here again after another week and ready for another episode in this series. Today we get to talk...
2010-08-30
1,766 reads
Memory
Not a sound from the pavement. Have you ever come across a SQL query that used to run faster? Has that...
2010-08-30
5,561 reads
Blogs
Microsoft Build 2026 announcements
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
T-SQL Tuesday #199: Roundup
A good week ago I hosted the monthly T-SQL Tuesday blog party. I invited...
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...
Forums
Increment a number in a SQL Query based on a value
I have an issue where I have a Bill of Material list of items...
Follow Your Hunch
Comments posted to this topic are about the item Follow Your Hunch
What Happens When You Ask a Local AI to Query Your Database?
Comments posted to this topic are about the item What Happens When You Ask...
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