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:…
Прошедшая неделя выдалась достаточно богатой на число партий, в которые удалось сыграть (особенно по сравнению с октябрем, когда почти не играли): Ticket To Ride: Europe -1 партия Dixit – 1 партия Черепашьи бега – 1 серия игр Во все игры играли впятером.Партия в Ticket To Ride прошла для меня достаточно просто: с самого начала я…
This post will end the first look on every day\every week planning with two reports: Hours Planned for Developers and Triage. The report Hours Planned for Developers gives simple picture what workload developers have on each week: Whether there are hours that stay in the past. Whether developer does not…
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…
I would like to speak about Aging Report this post. This report helps us to look on the age of Work Items. I want this report to show me not only some totals, but also allow me to drill through to each single work item that is out of date….
New really great feature appears in SQL Server 2008 – change data capture. In few words: Change data capture records insert, update, and delete activity that is applied to a SQL Server table. This makes the details of the changes available in an easily consumed relational format. Further details can be…
Straight to the point: this week I’ve faced an interesting SQL issue. Few words about environment where it has occurred: Enterprise system with SQL Server 2005 databases. All changes made by users are logged using internal mechanism to history tables. The mechanism looks like Change Data Capture, but this possibility…
На прошедшей неделе устроили внутрисемейную партию в Агрколу. Играли втроем: я, жена и сын, естественно в семейную версию игры без карт Простых улучшений и Занятий.Игра получилась очень интересной, я, к сожалению, допустил несколько ошибок, в итоге занял только второе место, отдав лавры победителя жене. Итоговый счет: 37–35–27.Про игру в двух…
Today I would like to focus on the main tool that my team is using for every day control of planning process. I called it Task Capacity report. If you are familiar with Microsoft Project and Gantе chart you will find much common between this tools and Task Capacity report,…
Let’s try to have a look at some SQL functions that are not very popular but can be very useful in some cases. Let’s imagine that we have the following task: replace all letters in a varchar column between first and last spaces with symbol ‘*’. The task can be…