SQL Server Startup
From time to time I see a question asking how to determine the last time a SQL Server was either restarted or when the last time was that the...
2011-03-23
8 reads
Jason Brimhall
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-23
1,530 reads
SQL Resource
By now, I am sure that you are well aware of the Resource Database. Starting with SQL Server 2005, a new system database was made available – the Resource...
2011-03-22
10 reads
SQL Resource
By now, I am sure that you are well aware of the Resource Database. Starting with SQL Server 2005, a...
2011-03-22
852 reads
Dedupe Data CTE
As a DBA working with SQL Server, some data issues arise that need to be fixed. One such data issue is the duplication of data. Duplicate data can happen...
2011-03-21
19 reads
Dedupe Data CTE
As a DBA working with SQL Server, some data issues arise that need to be fixed. One such data issue...
2011-03-21
1,389 reads
Database Tools Follow-up
After posting a database tools list yesterday, I found that there were things that I had forgotten and a couple of things that i hadn’t even considered. In thinking...
2011-03-18
4 reads
Database Tools Follow-up
After posting a database tools list yesterday, I found that there were things that I had forgotten and a couple...
2011-03-18
602 reads
Database Tools
Recently I have posted a couple of articles about various database or SQL tools either for maintenance or for benchmarking. Those posts work well in conjunction with a post...
2011-03-17
9 reads
Database Tools
Recently I have posted a couple of articles about various database or SQL tools either for maintenance or for benchmarking....
2011-03-17
4,456 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