Click here to Skip to main content
14,926,387 members
Home / Discussions / Database
   

Database

 
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 
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 
We use procedure that move tables into a recyclebin schema based on naming and date criteria (e.g. no live tables will contain digits in their names, but tables created/copied in response to support tickets will have the ticket number appended to the table name).

After a specified period (two weeks in our case) tables containing digits that were created prior to thespecified date are moved to the recycle bin schema. If someone screams that their table has gone, we move it back in to the original schema.

After another specified period (again two weeks), any table that has been in the recyclebin schema longer than that will be dropped.

This is all done automatically using an Agent job which calls a standard stored procedure we created.
=========================================================
I'm an optoholic - my glass is always half full of vodka.
=========================================================

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 
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 

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.