Worst Day of a DBAs Life
Red Gate Software is running a campaign around coping with the worst day of a DBAs life. We’ve been posting...
2014-07-08
869 reads
Grant Fritchey
- Twitter: @https://twitter.com/gfritchey
- Website: https://scarydba.com
- LinkedIn: https://www.linkedin.com/in/grant-fritchey/
- Bluesky: https://bsky.app/profile/gfritchey.bsky.social
Reflections on the 2014 PASS Summit Selection Process
Oh we are a bunch of high school kids at heart. Maybe high school never ends (and there’s a nightmare,...
2014-07-03
1,121 reads
Statistics and Natively Compiled Procedures
Statistics are one of the single most important driving factors for the behavior of the query optimizer. The cardinality estimates...
2014-07-03 (first published: 2014-07-02)
2,204 reads
The Curse of Working With A DBA
I no more than finished my rant from last week than I started thinking about all the reasons why a...
2014-06-30
1,641 reads
The Utility of Execution Plans in Natively Compiled Procedures
I’m actually having problems identifying the utility of execution plans when working with natively compiled procedures. Or, put another way,...
2014-06-30 (first published: 2014-06-25)
1,911 reads
Passion
I know I tend to be overly passionate. It’s something that has gotten me into trouble in the past. It’s...
2014-06-26
857 reads
The Curse of Relational Databases
Let’s face it, none of Information Technology is easy. Oh yeah, there are those few geniuses that have an absolute...
2014-06-23 (first published: 2014-06-18)
5,174 reads
Natively Compiled Procedures and Bad Execution Plans
I’ve been exploring how natively compiled procedures are portrayed within execution plans. There have been two previous posts on the...
2014-06-17
1,357 reads
Differences In Native Compiled Procedures Execution Plans
All the wonderful functionality that in-memory tables and natively compiled procedures provide in SQL Server 2014 is pretty cool. But,...
2014-06-13 (first published: 2014-06-10)
2,060 reads
Speaker of the Month, June 2014
It’s not like I can’t find plenty of great presentations here in the US, but, while I was over in...
2014-06-06
751 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
ALAMAT BCA KCU HR MUHAMMAD TLP/WA 0817839777
Bantuan Cs 0817839777 Jl. Mayjen HR. Muhammad No.17, Putat Gede, Kec. Sukomanunggal, Surabaya, Jawa...
BCA KCU BUKIT DARMO BOULEVARD Tlp:0817839777
Telp / Wa 0817839777 Jl. Mayjend. Jonosewojo No.14, Pradahkalikendal, Kec. Dukuhpakis, Surabaya, Jawa Timur...
ALAMAT KANTOR BCA KCU SIDOARJO TLP/WA 0817839777
Cs: 0817839777 Jl. Ahmad Yani No.39 A, Rw1, Sidokumpul, Kec. Sidoarjo, Kabupaten Sidoarjo, Jawa...
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