Click here to Skip to main content
15,917,538 members
Home / Discussions / Database
   

Database

 
QuestionRe: remote connection sql express 2008 Pin
mersad0010-Sep-10 10:45
mersad0010-Sep-10 10:45 
JokeRe: remote connection sql express 2008 Pin
mersad0010-Sep-10 10:51
mersad0010-Sep-10 10:51 
QuestionRecover SSIS file Pin
parth.p9-Sep-10 6:31
parth.p9-Sep-10 6:31 
QuestionAbout the datatype size Pin
Dhyanga9-Sep-10 3:08
Dhyanga9-Sep-10 3:08 
AnswerRe: About the datatype size Pin
PIEBALDconsult9-Sep-10 4:19
mvePIEBALDconsult9-Sep-10 4:19 
GeneralRe: About the datatype size Pin
Dhyanga9-Sep-10 5:29
Dhyanga9-Sep-10 5:29 
AnswerRe: About the datatype size Pin
Corporal Agarn9-Sep-10 6:58
professionalCorporal Agarn9-Sep-10 6:58 
GeneralRe: About the datatype size Pin
Dhyanga9-Sep-10 10:38
Dhyanga9-Sep-10 10:38 
QuestionEncrypt PostgreSQL Pin
Jassim Rahma9-Sep-10 3:07
Jassim Rahma9-Sep-10 3:07 
QuestionPostgreSQL or MySQL? Pin
Jassim Rahma8-Sep-10 3:55
Jassim Rahma8-Sep-10 3:55 
QuestionRe: PostgreSQL or MySQL? Pin
Paul Guralivu8-Sep-10 8:46
Paul Guralivu8-Sep-10 8:46 
AnswerRe: PostgreSQL or MySQL? Pin
Jassim Rahma8-Sep-10 10:00
Jassim Rahma8-Sep-10 10:00 
AnswerRe: PostgreSQL or MySQL? Pin
Jassim Rahma8-Sep-10 10:04
Jassim Rahma8-Sep-10 10:04 
AnswerRe: PostgreSQL or MySQL? Pin
Simon_Whale8-Sep-10 22:23
Simon_Whale8-Sep-10 22:23 
AnswerRe: PostgreSQL or MySQL? Pin
Bernhard Hiller8-Sep-10 22:41
Bernhard Hiller8-Sep-10 22:41 
AnswerRe: PostgreSQL or MySQL? Pin
David Skelly9-Sep-10 1:46
David Skelly9-Sep-10 1:46 
AnswerRe: PostgreSQL or MySQL? Pin
Daniel Casserly9-Sep-10 2:21
Daniel Casserly9-Sep-10 2:21 
GeneralRe: PostgreSQL or MySQL? Pin
Jassim Rahma9-Sep-10 2:53
Jassim Rahma9-Sep-10 2:53 
GeneralRe: PostgreSQL or MySQL? Pin
Bernhard Hiller9-Sep-10 3:42
Bernhard Hiller9-Sep-10 3:42 
GeneralRe: PostgreSQL or MySQL? Pin
Daniel Casserly9-Sep-10 4:10
Daniel Casserly9-Sep-10 4:10 
GeneralRe: PostgreSQL or MySQL? Pin
JChrisCompton9-Sep-10 8:13
JChrisCompton9-Sep-10 8:13 
Questionsql server 2005 maintainance plan good practice.... Pin
Sasmi_Office8-Sep-10 1:52
Sasmi_Office8-Sep-10 1:52 
Dear Friend,

help me come out of this issue....

i have one application on which more then 1000 user access daily and its create huge data transaction which need to be manage.

we have maintainance plan which run on weekly basis.

but still some time it slower down help me for this...

tell me some good practice for this issue...

i have some questions
1. What is statistics job does.

2.What task(s) is/are suitable for daily maintenance and what for weekly/monthly maintenance

3.Do database need to be offline while in some task, example : reorganize/rebuild index, Shrinking database, etc... (since we need to keep 90% uptime)

4.How long can check database integrity, reorganize/rebuild index, cleanup history be?

5.Should we do both reorganize and rebuild index?

6.Do we need to update statistic after reorganize index? Since rebuild index will auto update statistic


Please help me asap..

thanks
Sasmi

AnswerRe: sql server 2005 maintainance plan good practice.... Pin
Mycroft Holmes8-Sep-10 13:15
professionalMycroft Holmes8-Sep-10 13:15 
GeneralRe: sql server 2005 maintainance plan good practice.... Pin
Corporal Agarn9-Sep-10 1:18
professionalCorporal Agarn9-Sep-10 1:18 
QuestionSQL Server CAL Pin
divyesh14327-Sep-10 20:56
divyesh14327-Sep-10 20:56 

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.