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 and Performance 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, Tuning
Table indexing strategy is one of the most important performance tuning and optimization keys. In SQL Server, the indexes (both, clustered...
Functional F# that slowly appears in C#
For some reason, we often do not use this functionality. Maybe we haven’t got used to it yet. And...
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 convert rows to columns, resulting in pivot...
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...
5 Ways to Update Data with a Subquery in Oracle SQL
A subquery is a powerful way to find the data you want to use for another query. They are often used in SELECT and UPDATE statements to...
Resource Release in .NET Applications
In C#, there is one huge benefit, which is a drawback at the same time – an automatic garbage collection. With traditional desktop...
Setting Database Access Permissions
Server security mainly depends on how correctly you can configure access permissions on objects....
