We are constantly having to drop indexesfrom tables while repopulating the datain the table. We then have to rebuild the indexes as they were before dropping them.This requires writing a custom drop and recreate index script for each unique situation. If we tryto write scripts ahead of time as soon as the indexing schemechanges on […]
2002-08-06
925 reads
In this article, we will focus on creating a data pipeline to ETL (Extract,...
By HamishWatson
So in January I wrote a blog post on some goals I had this...
By HamishWatson
This blog post is about a situation that initially perplexed me – I was...
Hi, hope someone can help with this. I've the table gifts_to_give: Id_give number_of_gifts name ...
Hi, I've been struggling for 5 days to solved this issue. We have a...
Hi, I have a column in a table that contains variable semi-colon DB codes...
Ask SSC