SSAS: Attention, Accuracy, and All the Benefits
This article is about working with Microsoft Analysis Services and a little bit about the...
Introduction to Temporary Tables in SQL Server
A temporary table in SQL Server, as the name suggests, is a database table that exists temporarily on the database server. A temporary...
Why Multiple JOINs are bad for Query or Do Not Get in the Way of Optimizer
Recently, I came across an application that generated DB queries. I understand that there is nothing new about that, but when application...
CombGuid: Generation of SQL Server-friendly Guid Values in .NET Applications
Usage of UUID as a primary key for tables has a bunch of pros, including the option to retrieve IDs...
Pitfalls of Linked Server Usage
An interesting project related to the task queue processing come to the company I work for. It was previously developed by another team. We...
Dynamic T-SQL and Benefits of its Usage
In our projects, we have to cope with different tasks. To solve some of them, we use dynamic T-SQL. Why do we need dynamic T-SQL? Well, it...
SQL Server Security Ponderings
DBA is the guardian of the data, and there are two aspects of being a guardian. The first one is...
SQL Server: The dark side of NVARCHAR
Introduction In this article, we are going to talk about using the nvarchar data type. We will explore how SQL Server stores this data type...
What Can Query Plan Tell?
Introduction SQL query describes the expected result, not the way to get the result. The set of specific steps the server must take to...
Scheduled Maintenance of the 24/7 IS Database in MS SQL Server
Introduction This article is a short review of the main scheduled maintenance with a database of...
