Is Performance Better With LEFT JOIN or RIGHT JOIN?
I tend to write my queries using LEFT JOIN. Why? Because logically I see it in my head like this:
Give...
2015-05-20 (first published: 2015-05-11)
7,072 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
I Am Grateful For…
I’m almost done reading the book Connected (will be by the time this is published). It’s fascinating although, at least so...
2015-05-15
506 reads
Effects of Persisted Columns on Performance
I live for questions. And my favorite questions are the ones where I’m not completely sure of the answer. Those...
2015-05-13 (first published: 2015-05-05)
5,931 reads
Speaker of the Month: May 2015
I finally got out to some community events last month and got to see a bunch of great speakers. Not...
2015-05-01
508 reads
Benefits for Some, All or Only a Few
As a member of the PASS Board of Directors I attended the PASS Business Analytics Conference (BAC) recently. You can...
2015-04-27
518 reads
Azure SQL Database Firewall Settings
The new portal for managing Azure is pretty. I’m not sure I’m in love with it, but it’s pretty.
However, one...
2015-04-24 (first published: 2015-04-13)
5,249 reads
PASS Board Update: April 2015
It’s been a pretty interesting month on the board.
First, we did have a little problem. I’m sure one or two...
2015-04-23
527 reads
Query Hash Formula Changes Between Versions
The question came up on SQL Server Central that someone wanted to track queries on their 2008R2 instance and on...
2015-04-21
626 reads
Azure SQL Database v12 and SQL Magazine
I spend many of my evenings researching and writing. Sometimes it’s writing new books. Sometimes it’s fixing and rewriting old...
2015-04-16
683 reads
Constraints and SELECT Statements
I’ve posted previously about how a foreign key constraint can change how a SELECT query behaves. Logically that just makes...
2015-04-16 (first published: 2015-04-06)
7,520 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