The 'smart' delete

Deleting rows from SQL Server database table is not as simple as it sounds.

The ‘straight forward’ delete – go delete, no matter what!

Yes, there is the DELETE statement:

?View Code TSQLDELETE table_1 WHERE ColumnName = ‘some_value’

What is the problem with that?

There are several problems:

transactions and logging
disk space
time consuming
locking and concurrency
IO throughput
parallelism, if present

So, it depends how

Continue reading […] The ‘smart’ delete […]

 

Can partitioning solve it all?

Recently I got a question:

We are thinking to use partitioning for our DW database, since we have monthly incoming data of 30 million rows and partitioning will make the reads and writes much faster; we are using a 2 CPU machine with 16 Gb, 2 hard drives of 500Gb each.

Could you recommend a good strategy

Continue reading […] Can partitioning solve it all? […]

 

Using Louis Vuitton and an Army bag to store your historical Data

This is a guest post by Christoph Hanser. Christoph is currently working as a freelancer in .NET, SQL Server, and BizTalk projects. He is originally from Hamburg but has studied also for a semester in Sweden at the Uppsala University. His blog is http://eai-technologies-and-their-pitfalls.blogspot.com/.

What does a fancy Louis Vuitton and an armee bag have in

Continue reading […] Using Louis Vuitton and an Army bag to store your historical Data […]