Separating Out Indexes
I saw a post recently where someone was asking how to separate out all indexes from the data into a...
2009-10-15
907 reads
Blog Posts
SNESSUG October Meeting
The Southern New England SQL Server Users Group’s October meeting was a bit sparsely attended with 7 attendees. The sponsor...
2009-10-15
704 reads
SQL Lunch/Call for Speakers
Patrick Leblanc has started a new project called…SQL Lunch! The concept is to present a 30 minute topic every two...
2009-10-15
885 reads
SQL MVP Profile of the Week - Michael Coles
As we continue to get ready for the NY\NJ SQLSaturday User Group meeting this October 24, 2009, I had the...
2009-10-15
1,161 reads
SQLSaturday #21 Is Tomorrow (Oct 17)
I’m writing this in advance because I’ll be busy with all the last minute preparations, but I’m looking forward to...
2009-10-15
289 reads
The PASS Board of Directors Election
There has been some great discussion about the upcoming PASS Board of Directors election over on Brent Ozar’s blog. If...
2009-10-15
1,257 reads
120 DBAs and Developers Attend SQL Down Under
The fourth annual SQL Down Under Code Camp was held at Charles Sturt University in Wagga Wagga, Australia this past...
2009-10-14
381 reads
Dev Days – Austin
I’m out of the office today, in Austin, TX (yee-haw!) at the Stack Overflow Dev Days – Austin. There are a...
2009-10-14
760 reads
DRP for SQL Server in French - traduction en français du plan de relève – part 4
La liste des fichiers restaurés devrait se trouver dans le répertoire suivant :
\\ServeurDeBD\Disque$\DirSauvegardesProd\DBlog\
Dès que la restauration a été complétée, nous...
2009-10-14
814 reads
Free T-SQL Database Maintenance Scripts
I often get questions in e-mails, or at user group meetings, for advice on writing T-SQL database maintenance scripts. There...
2009-10-14
4,307 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
Alamat kontak resmi BCA KCP Tebet Telp:0818751777
WhatsApp:0818-751-777 Gedung Gajah Tebet, Jl. Dr. Saharjo No.Raya 111 Unit N & O, RT.1/RW.1,...
Stan Phone Number Australia +61-1800868603 Quick Help Guide
When things go wrong - like trouble signing in, videos pausing, unclear charges, or...
BCA KCP Pasar Minggu Center | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Jl. Lenteng Agung Raya No.26 E-F, RT.1/RW.4, Ps. Minggu, Kota Jakarta Selatan, Daerah...
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