Variables, Parameters And Columns Data Types
Ensure your variables and parameters are the same data types as the columns. An implicit or explicit conversion can lead to table scans and slow performance.
Recent Posts
Move Only The Data You Require
SELECT * is not necessarily a bad thing, but it’s a good idea to only move the data you really need to move and only when you really need it, in order to avo...
Sql String Data Types Which One
When creating a field which will contains text, it is important to choose the right string type in order to save space and increase performance.
Only Load What’s Needed
Implement different database queries in different contexts. In the API and on a webpage, you’ll inevitably require different entity properties, so don’t load...
Profile Your Orm Database Hits
Always profile your ORM database hits with SQL Profiler during development. ORMs get away from you very quickly. Before you know it, you’ve run a query 2000 ...