A SQL Server is as fast as you tune your workload. One of the things I try to do is tune the workload, a.k.a. the queries executing on my SQL Server, in order to get a better performing server. I start by looking atqueries that do too many reads to retrieve a small result set. A possible obstacle, however, when working with vendor applications, is that you might not be able to tune the applications queries. This definitely limits your options, but there are still a lot of thing you can do to optimize your workload. Today we will do some testing with a giant read query and tune it in different ways by using real life scenarios.
SQL Server consultancy
When you think SQL Server, think Kohera. Whether you're looking for expert SQL database administrators, an audit of your systems, any type of performance tuning, database consolidation and migration, on-premises or hybrid our cloud software, high availability or disaster recovery set-ups, we will always find the best solution at the lowest cost.Read more