Nagaraj·Oct 225 SQL Server Basics Seniors Still Get Wrong (I Measured Them)5 Everyday Habits That Cost 5 Million Logical Reads
InTowards DevbyNagaraj·Oct 2Your SQL Query Is Slow Because You Checked the Wrong ThingGet Real bottleneck theory in SQL Server in 5 checks for them.
Subinthapa·Sep 12SQL Server From the Ground Up: A Practical Guide to T-SQL, Joins, CTEs, and ViewsFrom CREATE TABLE to Practical Analytical Queries, Built on One Consistent Database
InStackademicbyDhanushKumar·Sep 1The Complete Engineering Guide to Writing Advanced T-SQLWriting correct, set based SQL is a baseline expectation for any engineer working against SQL Server. Writing advanced T-SQL is a different…
InAny ProgrammingbyNoman Kamran·Aug 31Calculating Geographic Distance in SQL ServerA practical comparison of the Haversine formula and SQL Server’s GEOGRAPHY type for nearest-location queries
