It's Over - SQL Server 2000 Support
Ok, I'm a bit of an ID10T at times.
I've talked about this for months, especially trying to push SP3 for...
2008-04-09
794 reads
Blog Posts
Partitioning Gotcha
Well, it got me at least! Not long ago someone asked me about partitioned views and as I'm apt to...
2008-04-08
413 reads
SQL Server 2008 Management Studio
I made the decision today to start using SQL Server 2008 Management Studio at work to manage my 2000 and...
2008-04-08
814 reads
After Event Party Location Announced for SQLSaturday#3 in Jacksonville
From the SQLSaturday event site:
AFTER EVENT PARTY ANNOUNCED! Our after event party will be held at 7 Bridges Grille beginning...
2008-04-07
575 reads
Heroes Happen Here Charlotte, NC Launch Tomorrow (April 8, 2008)
The Heroes Happen Here launch event for Charlotte, NC is tomorrow. It looks like there are still registration slots open:
Heroes...
2008-04-07
1,010 reads
Link: April Fools Joke on Jonathan Schwarz of Sun
Absolutely worth watching.
http://blogs.sun.com/jonathan/entry/the_video
2008-04-07
518 reads
SQL Compare 7 Beta
Red Gate's schema comparison tool, SQL Compare, is in beta for the newest version, SQL Compare 7. You can find...
2008-04-07
1,201 reads
Thoughts on Database Mail
I suspect few would argue that database mail in SQL 2005 is a huge improvement over the mail system in...
2008-04-07
306 reads
A Note on sp_updatestats
In SQL 2000 when you run sp_updatestats it's the equivalent of running UPDATE STATISTICS on each table, forcing the update...
2008-04-06
417 reads
Jacksonville SQLSaturday less than a month away!
The SQLSaturday in Jacksonville, Florida, will be held May 3, 2008. I'm on track now to give two security based...
2008-04-05
535 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