In our previous article we saw the great advantages of applying Best Programming Practices in SQL Server. We’d like to explore this further, this time focusing on query optimization. SQL is a declarative language: each query declares what we want the database engine to do, but it doesn’t say how. However, it turns out that the how (the plan) is what affects the efficiency of the queries, so it...
Fernando Tomas Rodriguez
Best programming practices for relational databases and cost savings
No time is a bad time to plan improvements. Looking for ways to reduce development costs in the cloud is always a good thing. Process response times in Microsoft SQL Server databases are irreparably deteriorating as our data volume grows. Therefore, we must stay one step ahead by improving our infrastructure and the way we act towards them. Everything can always be improved without needing to...
Categories