In this post I would like to speak about currency rates calculations in standard dimension model, and in the next post I would return to Tabular model, DAX language and perform the same calculations there. It’s quite a common business task when you have to provide business with prices and…
While creating SQL queries for reports, it’s usually required to get a continuous list of dates for a given period. E.g.: get all dates from 1980 Jan 01 till 2013 Dec 31 (12419 records). In this post I would like to describe several ways how this can be done and…
In this post let’s dwell on adding messages to queues. In our system we prefer doing it inside triggers. Why triggers? There are several reasons: You cannot miss trigger event, whenever you perform update through web-service, or direct in the database. Trigger is always inside your transaction. Also you can…
First, let’s start from advantages of Service Broker (SB) – why it can be useful. I will list main points and examples how we use it. SB provides mechanism of asynchronous queue. This gives us an opportunity to move some hard SQL procedures from users’ transactions. E.g.: we had stored…
In this post I would like to start a series how we use Service Broker in our enterprise system. Today I would like to speak about target scheme that we were planning to archive several years ago, later I would dwell on how we have developed it. I will not…
Not so long ago we have faced the following problem while implementing SQL jobs to test and production environment: Job is developed be developer by deployed to test or production by DBA. E-mail lists, folders are different on each environment. So the process was the following: developer come and together…
One developer from my team has made the following suggestion: why not to alter all views we have in ERP system with SCHEMABINDING option? His main argument was: this would help us to set additional control for changes in tables’ structures, thus increasing system stability. The idea was interesting, so…
In this post I would like to finish my Change Data Capture practice. So I had not described the update of history table. All details about database structure can be found in the early post http://borisfrolov.com/2012/10/28/change-data-capture-practice-experience-part-2/. As I have told everything about architecture of the designed solution, in this post…
In this post I would like to describe step-by-step process how a query can be optimized. This is taken from real practice I faced not so long ago. So, I’ve got a query that joined about 20 tables, had ORDER BY statement and rather complex WHERE clause that looked like:…
Continue speaking about Change data capture I would like to start from the detailed description of the tables with business data database structure. The structure looks like: Just few words about each table: ABSMainRate– for every change in users’ database cause new record in this table. REV – is the…