Ben Johnston in SQL Server How to write an efficient SQL query: practical guidelines for faster, lighter queries Practical guidelines for writing efficient SQL queries: sargable predicates, set-based operations, index candidates, and how to read a query plan.… 19 October 2024 21 min read 3
Ben Johnston in Databases How to choose the right data types and column options in databases How to pick the right SQL Server data type for every column - covering size, performance, NULLs, and the code... 31 August 2024 28 min read 11
Nick Harrison Back to Basics: Wiring up a Web Application In the third of a series on Web Application design, Nick turns his attention to the Model part of the... 18 June 2010 12 min read
