Few technologies in SQL Server cause as much confusion to a developer than indexes. Indexes operate “behind the scenes”: adding and removing indexes rarely result in changes to an application’s code. The proper index can drastically increase the performance of an application. However, there are tradeoffs to almost any feature, and indexes are no exception. … Read more

SQL Server Performance tuning is a vast topic that can be a complicated and struggling task. Fix a slow query and solve performance problems can involve hours of research and tests. Today I will show how you can use the query wait statistics to troubleshoot a slow running query on Microsoft SQL Server. Query wait … Read more

Amazon AWS and Microsoft Azure are excellent options for deploying MS SQL Server databases. Many companies use both to enjoy each Cloud’s unique feature set. However, it’s essential to compare the features, advantages, and limitations between them before you decide on an Amazon AWS or Azure migration. In this post, we’ll see a high-level of … Read more

Today I will let know some essential techniques that never change to make your queries run faster in the Microsoft SQL server! It is excellent to deploy an optimized product that runs a dozen times faster than the previous version. Performance tuning is a vast topic that can be a complicated and struggling task to … Read more

It’s not enough that your code is readable: it must perform well too. In this post, I will show a list of common antipatterns in TSQL coding that make code perform badly. They are cumulative. Just don’t make these mistakes, and you’ll be much better off. 1- Not making predicates SARGable What is SARGable? Sargable … Read more

FREE Scripts to Instantly
Improve SQL Server Performance

3 FREE Scripts to Instantly
Improve SQL Server Performance

Learn how to increase Performance of SQL Server INSTANTLY with 3 free scripts.