Click here to Skip to main content
14,923,435 members
Home / Discussions / Database
   

Database

 
QuestionPruning unused tables in a live database. Pin
mbb0113-Jul-17 2:43
Membermbb0113-Jul-17 2:43 
AnswerRe: Pruning unused tables in a live database. Pin
Mycroft Holmes13-Jul-17 13:31
professionalMycroft Holmes13-Jul-17 13:31 
AnswerRe: Pruning unused tables in a live database. Pin
Chris Quinn14-Jul-17 0:09
MemberChris Quinn14-Jul-17 0:09 
GeneralRe: Pruning unused tables in a live database. Pin
mbb0114-Jul-17 0:37
Membermbb0114-Jul-17 0:37 
GeneralRe: Pruning unused tables in a live database. Pin
Chris Quinn14-Jul-17 0:48
MemberChris Quinn14-Jul-17 0:48 
AnswerRe: Pruning unused tables in a live database. Pin
Eddy Vluggen14-Jul-17 2:39
professionalEddy Vluggen14-Jul-17 2:39 
AnswerRe: Pruning unused tables in a live database. Pin
Tim Carmichael14-Jul-17 8:57
MemberTim Carmichael14-Jul-17 8:57 
AnswerRe: Pruning unused tables in a live database. Pin
jschell15-Jul-17 9:33
Memberjschell15-Jul-17 9:33 
mbb01 wrote:
are there any good reasons for running the risk of removing defunct tables from a live system?


Sure. If there is a table with 100 million rows then removing it saves that space in a number of contexts. Obviously not as much an issue with 3 rows.

Additionally there is a maintenance issue. If there is an old table that Bob knows is no longer in use and then Bob dies and they hire Sharon to replace him the only way she can figure out that the table is not in use is to go through the entire code base. Not so much a problem if the is 100 lines of code but a real problem with 100 million lines of code (and poorly organized code at that.)

Same if Bob is on vacation and a new table replaced the old one but the data still exists in the old one. Sharon needs to make an emergency fix and ends up looking at the old one, and the data sort of looks correct, so that is what gets fixed.

Obviously that latter problem won't be a problem in there is sufficient testing in place to adequately test the enterprise. But if that is true then removing old cruft isn't a problem either because that same testing will demonstrate problems with that as well.

mbb01 wrote:

Apart from those of us who are hopelessly OCD about these sort of things


Me I am in the camp that there better be enough testing in place, both automated and manual, that changes have a minimal risk because changes will be needed even if old information is not removed. And I can't see that insuring functionality with additions and modifications would not cover deletions as well.

Or there is not sufficient testing in place and that is a problem.
AnswerRe: Pruning unused tables in a live database. Pin
Mycroft Holmes15-Jul-17 14:43
professionalMycroft Holmes15-Jul-17 14:43 
GeneralRe: Pruning unused tables in a live database. Pin
Jörgen Andersson17-Jul-17 10:28
professionalJörgen Andersson17-Jul-17 10:28 
Questionhow to rertrieve only 3 columns out of 7 columns using queryForObject in jDBCTmplate????am unable use correct syntax to retrieve only 3 columns in JdbcStudentDAO Pin
LOKENDRA YADAV12-Jul-17 21:09
MemberLOKENDRA YADAV12-Jul-17 21:09 
SuggestionRe: how to rertrieve only 3 columns out of 7 columns using queryForObject in jDBCTmplate????am unable use correct syntax to retrieve only 3 columns in JdbcStudentDAO Pin
Richard Deeming13-Jul-17 7:57
mveRichard Deeming13-Jul-17 7:57 
QuestionWant to Import Data from Salesforce into SQL Server using SSIS Pin
indian14312-Jul-17 10:35
Memberindian14312-Jul-17 10:35 
AnswerRe: Want to Import Data from Salesforce into SQL Server using SSIS Pin
Mycroft Holmes12-Jul-17 14:23
professionalMycroft Holmes12-Jul-17 14:23 
GeneralRe: Want to Import Data from Salesforce into SQL Server using SSIS Pin
indian14317-Jul-17 8:02
Memberindian14317-Jul-17 8:02 
GeneralRe: Want to Import Data from Salesforce into SQL Server using SSIS Pin
Richard MacCutchan17-Jul-17 9:48
mveRichard MacCutchan17-Jul-17 9:48 
AnswerRe: Want to Import Data from Salesforce into SQL Server using SSIS Pin
Member 1362406015-Jan-18 6:13
MemberMember 1362406015-Jan-18 6:13 
QuestionGet following Error when Loading the SSIS Package using C# Code Pin
indian1436-Jul-17 14:04
Memberindian1436-Jul-17 14:04 
AnswerRe: Get following Error when Loading the SSIS Package using C# Code Pin
Richard Deeming7-Jul-17 0:47
mveRichard Deeming7-Jul-17 0:47 
GeneralRe: Get following Error when Loading the SSIS Package using C# Code Pin
indian1437-Jul-17 8:44
Memberindian1437-Jul-17 8:44 
GeneralRe: Get following Error when Loading the SSIS Package using C# Code Pin
indian14310-Jul-17 9:37
Memberindian14310-Jul-17 9:37 
GeneralRe: Get following Error when Loading the SSIS Package using C# Code Pin
Richard Deeming10-Jul-17 9:50
mveRichard Deeming10-Jul-17 9:50 
GeneralRe: Get following Error when Loading the SSIS Package using C# Code Pin
indian14310-Jul-17 11:17
Memberindian14310-Jul-17 11:17 
GeneralRe: Get following Error when Loading the SSIS Package using C# Code Pin
Richard Deeming11-Jul-17 1:28
mveRichard Deeming11-Jul-17 1:28 
GeneralRe: Get following Error when Loading the SSIS Package using C# Code Pin
indian14312-Jul-17 7:38
Memberindian14312-Jul-17 7:38 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.