Blog - comments

Thanks Hemant for your feedback. Actually, each blog post about that subject brings 2 or 3 additiona...

Interesting series. Thanks. Keep it coming.

Hemant K Chitale
Thanks Oleg for your remark. I will add the check in the script as soon as possible and send a post ...
Stéphane
There need to check for 0 because of zero division for tables with 0 rows:SET @vQuery = 'SELECT @res...
Oleg
Hi Connor, Yes that's right it can improve the bulk load, reducing index maintenance overhead, gener...
Blog

dbi services Blog

Welcome to the dbi services Blog! This IT blog focuses on database, middleware, and OS technologies such as Oracle, Microsoft SQL Server & SharePoint, EMC Documentum, MySQL, PostgreSQL, Sybase, Unix/Linux, etc. The dbi services blog represents the view of our consultants, not necessarily that of dbi services. Feel free to comment on our blog postings.

  • Home
    Home This is where you can find all the blog posts throughout the site.
  • Categories
    Categories Displays a list of categories from this blog.
  • Tags
    Tags Displays a list of tags that have been used in the blog.
  • Bloggers
    Bloggers Search for your favorite blogger from this site.
Recent blog posts

If you followed the first, second and the third post the current ppas infrastructure consists of a primary database, a hot standby database and a backup and recovery server.

Tagged in: PostgreSQL
Hits: 90
Rate this blog entry:
0
Continue reading 0 Comments

For second day of conferences, I attended a first session about migration from Webtop to D2 or xCP. Then we attended 2 about Documentum platform performances tuning.

Hits: 115
Rate this blog entry:
0
Continue reading 0 Comments

EMC World 2015 - Day 2 at Momentum

Posted by on in Middleware

Second day in this amazing event. There are not only general and presentation sessions you can also participate on a so called "Hands-on Lab". The subject was the "EMC Documentum Platform Performance Tuning". So learning by doing is also a good opportunity you can use at Momentum to enhance your skills.

Hits: 215
Rate this blog entry:
0
Continue reading 0 Comments

 

Tagged in: SQL Server 2016
Hits: 114
Rate this blog entry:
0
Continue reading 0 Comments

A couple of weeks ago, I had an interesting discussion with one of my friend that faced a weird issue with a SQL Server instance that lacked worker threads. Because I can’t use his own information I decided to reproduce the same issue in order to share with you some interesting information. So the next part of this blog post refers exclusively to my own test but it represents exactly the real issue encountered by my friend.

Hits: 107
Rate this blog entry:
0
Continue reading 0 Comments


I guess you all already know what a lifecycle is. We born, we live and we die... In fact, it's exactly the same for Aflresco Nodes! Well, at least from an end user point of view. But what is really going on behind that? This is what I will try to explain in this post.

Hits: 105
Rate this blog entry:
1
Continue reading 0 Comments

Since SQL Server 2014 CTP2, Microsoft has introduced a new kind of index which is the Range index. We have now two ways for indexing an In-Memory table: using either an Hash index or a Range index.

Hits: 181
Rate this blog entry:
1
Continue reading 0 Comments

In the previous blog post I measured how inserting 1 million rows takes 5 minutes instead of 45 seconds when we commit at each row inserted. In Oracle we can improve that down to 2 minutes if we can accept (and manage) the loss of transactions following an instance crash.
Let's go further. For OLTP that need to face a high rate of transactions, Oracle has TimesTen which is a Database In-Memory - meaning that it is optimized for in-memory structures. My testcase has a 1 million rows table that can fit in memory, so let's try it.

Hits: 98
Rate this blog entry:
0
Continue reading 0 Comments

Before starting talking about EMC event, I just would like to share my feeling about the city it takes place. It is Las Vegas, ok, what an amazing, impressive place! On top of that, we are in one of most beautiful hotels on the strip ! Congratulations to EMC and thanks for this attention.

Tagged in: D2 Documentum EMC xCP
Hits: 67
Rate this blog entry:
1
Continue reading 0 Comments
Franck was quite fast with his second post Variations on 1M rows insert(2): commit write. Lets see what we can do on the PostgreSQL side.
Tagged in: PostgreSQL
Hits: 88
Rate this blog entry:
0
Continue reading 0 Comments
AddThis Social Bookmark Button
Deutsch (DE-CH-AT)   French (Fr)

Contact

Contact us now!

Send us your request!

Our workshops

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

Expert insight from insiders!

Fixed Price Services

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

A safe investment: our IT services at fixed prices!

Your flexible SLA

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

ISO 20000 certified & freely customizable!

dbi services Newsletter