Dynamic SQL vs Stored Procedure
Dynamic SQL and stored procedures are among the most important SQL Server components. Both have...
Using Indexes in SQL Server Memory-Optimized Tables
Introduction In this article, we will discuss how different types of indexes in SQL Server memory-optimized tables affect performance. We...
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...
SQL Server Index Backward Scan: Understanding, Tuning
Table indexing strategy is one of the most important performance tuning and optimization keys. In SQL Server, the indexes (both, clustered...
SQL Server Index Backward Scan: Understanding and Performance Tuning
Table indexing strategy is one of the most important performance tuning and optimization keys. In SQL Server, the indexes (both, clustered...
Creating Dynamic Pivot Table with QUOTENAME Function
In my previous article on the basic pivot operator, we saw how pivot operator could be used to...
Database Optimization: Indexes
I noticed that very few people understand how indexes work in SQL Server, especially Included Columns. Nevertheless, indexes are the great...
Methods to Rank Rows in SQL Server: ROW_NUMBER(), RANK(), DENSE_RANK() and NTILE()
SQL Server provides us with a number of window functions that help us to perform calculations across a set of rows, without the need to...
Setting Database Access Permissions
Server security mainly depends on how correctly you can configure access permissions on objects....