Click here to Skip to main content
14,930,815 members
Home / Discussions / Database
   

Database

 
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 
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 
Thanks Chris, I'll certainly put forward your good ideas to our DBAs.

But ... you answered how, not why? Implicit in your answer is the acceptance that the live database should reflect what it 'should' be from Dev.

What are the reasons (technical or business) why a live system should reflect exactly what is in Dev, when those superfluous tables are not really harming the operation of the live system?

Any insights would be appreciated.
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 
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 

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.