PASS Subcommittee
In February I posted this post about the need for Volunteers for SUMMIT 2011. I submitted my application to volunteer....
2011-03-31
1,541 reads
Jason Brimhall
NULLIF
Do you use NULLIF? For me, this command has been seldom used. Because of that, I have been dabbling with it a bit lately to make sure I have...
2011-03-30
13 reads
NULLIF
Do you use NULLIF? For me, this command has been seldom used. Because of that, I have been dabbling with...
2011-03-30
3,892 reads
Do You Solution?
Do you ever find yourself working on different scripts at once? Maybe you are working on something that tests certain functionality in SQL Server, you have some presentation scripts...
2011-03-29
8 reads
Do You Solution?
Do you ever find yourself working on different scripts at once? Maybe you are working on something that tests certain...
2011-03-29
917 reads
ShowPlan XML
I just ran into something that I hadn’t noticed in SQL Server. It struck me as somewhat interesting but is really not too big of a deal. While demonstrating...
2011-03-28
21 reads
ShowPlan XML
I just ran into something that I hadn’t noticed in SQL Server. It struck me as somewhat interesting but is...
2011-03-28
1,927 reads
SQL Server Startup
From time to time I see a question asking how to determine the last time a SQL Server was either...
2011-03-25
1,313 reads
Tools note
I was asked a few months ago to allow some advertising on my blog. I hadn’t given the idea a whole lot of thought but was reminded again today...
2011-03-24
10 reads
Tools note
I was asked a few months ago to allow some advertising on my blog. I hadn’t given the idea a...
2011-03-24
844 reads
Blogs
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...
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...
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