Click here to Skip to main content
14,924,621 members
Home / Discussions / Database
   

Database

 
GeneralRe: IF then ? Pin
Chris Quinn20-Jul-17 21:22
MemberChris Quinn20-Jul-17 21:22 
GeneralRe: IF then ? Pin
Richard Deeming21-Jul-17 0:15
mveRichard Deeming21-Jul-17 0:15 
AnswerRe: IF then ? Pin
Pradeep Magati11-Aug-17 2:58
MemberPradeep Magati11-Aug-17 2:58 
QuestionSetting values from a Pivot to 0? Pin
patsq18-Jul-17 4:55
Memberpatsq18-Jul-17 4:55 
AnswerRe: Setting values from a Pivot to 0? Pin
Chris Quinn18-Jul-17 5:01
MemberChris Quinn18-Jul-17 5:01 
GeneralRe: Setting values from a Pivot to 0? Pin
patsq18-Jul-17 5:08
Memberpatsq18-Jul-17 5:08 
GeneralRe: Setting values from a Pivot to 0? Pin
patsq18-Jul-17 5:24
Memberpatsq18-Jul-17 5:24 
QuestionPruning unused tables in a live database. Pin
mbb0113-Jul-17 2:43
Membermbb0113-Jul-17 2:43 
This isn't a question about how to detect and prune unused tables in a live database. I'm more interested in the reasons why it should be done at all.

Here's some context. In our development environment we maintain a production database from which a schema and upgrade script is generated. When a database is upgraded it will create or alter existing tables on a live system, but not remove any tables.

After a debate about how it could be done and whether it should be done, I was struck by my colleague's statement of 'a lot of effort and potential pain, for not much gain'. There is of course the obvious risk of removing a table that really is used and causing a live system to fail.

There didn't seem to be much debate on whether defunct tables should be removed from a live database on the internet.

Apart from those of us who are hopelessly OCD about these sort of things, are there any good reasons for running the risk of removing defunct tables from a live system?
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 
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 

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.