Time’s Makin’ Changes
Some History Almost exactly 7 years I ago my wife and I decided to apply to be missionaries with New Tribes Mission. We decided at that time to...
2011-02-03
4 reads
Blog Posts
Time’s Makin’ Changes
Some History
Almost exactly 6 years I ago my wife and I decided to apply to be missionaries with New Tribes...
2011-02-03
786 reads
What SQL Server Service Pack Do I Have Installed?
If you’ve used SQL Server for a while, you’re probably familiar with the @@version function. @@ variables are system variables that...
2011-02-03
852 reads
Who Changed Jobs in 2010?
Linked in sent me an email saying that an astounding 209 of my connections changed jobs in 2010, out of...
2011-02-03
539 reads
A Full Backup can Impact a Log Backup–MCM Prep
In the early days of SQL Server you could not run a log backup while a full backup was running....
2011-02-02
2,925 reads
A Mish Mash of Stuff
I don’t generally post bits of this and that, but I’ve accrued a few things that I wanted to share,...
2011-02-02
601 reads
February 2011 Version of SQL Server 2005 and 2008 Diagnostic Information Queries
Wow, it is already February 2011, so here are the February 2011 versions of the SQL Server 2005 Diagnostic Information...
2011-02-02
1,931 reads
Meet Me In Florida!
While much of North America is bracing for the Snowpocalypse 2011, my thoughts are turning to sunny Florida.
I’m not just...
2011-02-02
748 reads
PASS Summit Location
Andy Warren has posted another one of his excellent summaries of what’s going on at the PASS Board. Andy, thanks...
2011-02-02
1,913 reads
2011-02-02
9 reads
Blogs
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...
Finally Cleaning Up Dropbox: Moving Almost a TB to Google Drive with rclone
By davebem
I’ve had a Dropbox account for years. Like a lot of people, I started...
Forums
identity increments by 10,000 when it was supposed to be 1
hi a peer of mine who ive never known to be wrong says a...
Displaying Money
Comments posted to this topic are about the item Displaying Money
The Slow Growing Problems
Comments posted to this topic are about the item The Slow Growing Problems
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