The Last DBCC CHECKDB Date and Restores
I ran across a question on Twitter recently where someone asked about the DBCC CHECKDB date after a restore. For...
2012-11-28
3,446 reads
I ran across a question on Twitter recently where someone asked about the DBCC CHECKDB date after a restore. For...
2012-11-28
3,446 reads
Today Steve Jones says your learning should have a plan. He uses an example from a recent conference where one motivated attendee came with a plan.
2012-11-27
199 reads
Today Steve Jones reminds us that we should analyze and re-evalute our indexing strategy on a regular basis.
2012-11-26
318 reads
2012-11-22
156 reads
2012-11-22
2,839 reads
It's incredible what humans can accomplish when they work on a problem with passion. This editorial was originally published on Mar 20, 2008. It is being re-run as Steve is on vacation.
2012-11-19 (first published: 2008-03-20)
315 reads
This week Steve Jones looks at the expected lifetimes of SSDs and finds one that might be a nice upgrade for your system.
2012-11-19
257 reads
As DBAs we constantly need more storage, but do we know what the impact or cost of this storage is to our employers? Answer this week's poll.
2012-11-16
142 reads
I delivered my Encryption Primer talk this past Tuesday at the Boulder SQL Server Users Group and last night at...
2012-11-16
1,082 reads
I’ve been giving an encryption talk over the last year, focusing on educating DBAs on the various features and capabilities...
2012-11-15
1,352 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...
Tlp/Wa_Cs:0817-866-887. Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, RT.1/RW.5, Menteng, Kec. Menteng, Kota...
WhatsApp:0818-751-777 Gedung Gajah Tebet, Jl. Dr. Saharjo No.Raya 111 Unit N & O, RT.1/RW.1,...
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