Database – Tri Tran

Hey ! I’m Tri Tran – a software engineer. I’m passionate about programming, aerospace and aviation, and technology.

“How do you share what you learn?” is a question I’ve been thinking a lot about, particularly as chat programs like Slack become popular in workplaces. At conferences, I now see people sharing on Slack or in private Facebook groups instead of Twitter. This is fine, of course, but it isn’t necessarily sharing knowledge publicly. As we continue to share with smaller communities, it feels like we’re heading towards the opposite of an open web.

So I’m happy to share with my friends what I’ve learned, about conventional and unconventional lessons, on this blog without any expectation and not necessarily in a discoverable or searchable way.

Sincerely your.

Computer Science, Database, Software Development

How to design indexes

One of the most common reasons for performance issues in software applications is missing or incorrect database indexes, so the goal of this article is to provide an introduction to the concepts and real-world practice of indexing for developers.

Read More
Database, Software Development

Parameter Sniffing

References https://hackernoon.com/why-parameter-sniffing-hurts-your-sql-query-performance-d73c0da71fbc https://blogs.technet.microsoft.com/mdegre/2011/11/06/what-is-parameter-sniffing/ https://www.mssqltips.com/sqlservertip/3257/different-approaches-to-correct-sql-server-parameter-sniffing/

Read More