Monthly Archives: October 2012

Change data capture. Practice experience. Part 2.

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 … Continue reading

Posted in Database development, SQL Server, Technology | Tagged , | 1 Comment

Change data capture. Practice experience. Part 1.

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 … Continue reading

Posted in Database development, SQL Server, Technology | Tagged , | 2 Comments

“TempDB is full” error: solving interesting SQL Server issue.

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. … Continue reading

Posted in Database development, SQL Server, Technology | Tagged , , | 3 Comments

Some Useful String Functions in SQL

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 … Continue reading

Posted in Database development, SQL Server, Technology | Tagged , , , | Leave a comment