Top 3 Tips You Need to Know to Write Faster SQL Views
Friend or foe? SQL Server views have been a subject of heated debates when I was in my first year...
Parameter Sniffing Primer
Introduction Developers are often told to use stored procedures in order to avoid the so-called ad hoc queries which can result in...
Compare Execution Plans in SQL Server
Database Administrator always makes an effort to tune SQL Server query performance. The first step in tuning query performance is to...
Exploring SQL Server 2016 Query Store GUI
Introduction Query store is a new feature, introduced in SQL Server 2016, that allows database...
SQL Server Database Scoped Configurations and Automatic Plan Correction
In this article, we will examine Database Scoped Configurations and SQL Server 2017 Automatic Plan Correction. Microsoft added new features...
T-SQL BEST Practices
In this article, we will discover some best practices of T-SQL queries. Badly written queries can cause performance and I/O problems. For...
SQL Server Trigger: Understanding and Alternatives
The SQL Server trigger is a special type of stored procedures that is automatically executed when...
Example of Improving Query Performance with Indexes
In this article, we’ll look at how an index can improve the query performance. Indexes in Oracle and other databases are objects that...
Implementing a Common MS SQL Server Performance Indicator
Introduction There is often a need to create a performance indicator that would show database activity related to the previous period or...
Missing Indexes in MS SQL or Optimization in no Time
When executing a query, the SQL Server optimizer tries to find the best query plan based on...
