How I Optimized a Painfully Slow Cross-Server JoinI had a simple requirement. Pull data from Server 1.Join it with a table in Server 2.Return the result. Simple on paper. Painfully slow in reality. The cross-server join was taking an unacceptable amoFeb 28 · 4 min readproduction-diaries.hashnode.dev
Linked Servers and the Truth About #TempTablesThis week’s learning was less about application code and more about database architecture. Two topics stood out: How to link different DB servers in SSMS How #TempTables actually work under the hoodFeb 28 · 5 min readproduction-diaries.hashnode.dev
When “300” Became Greater Than “2500”Production Diaries #1 – When “300” Became Greater Than “2500” A withdrawal request for $300 was rejected. The user had \(2500 in holdings. The system insisted \)300 was greater than $2500. This was noFeb 28 · 4 min readproduction-diaries.hashnode.dev
Guidewire | SDE Intern Interview Experience (Off-Campus)I applied to Guidewire for an SDE Intern position off-campus, without much expectation.It was one of those applications you send out quietly, hoping it at least gets noticed. About a week later, I received an email saying my profile had been shortlis...Feb 7 · 3 min readfaisal-interview-diaries.hashnode.dev
My Hexaware Interview Experience: When Timing, Pressure, and Preparation Fell ApartMy Hexaware Interview Experience: When Preparation, Timing, and Pressure Didn’t Align Role: Java Developer | Package: 4.5 LPA | Type: On-Campus | Year: B.E This interview was short, intense, and honestly a little frustrating. Not because the question...Jan 17 · 5 min readfaisal-interview-diaries.hashnode.dev
