Click here to Skip to main content
15,844,011 members
Home / Discussions / Database
   

Database

 
GeneralRe: SQL Advice needed Pin
Daniel Turini23-Jul-08 10:35
Daniel Turini23-Jul-08 10:35 
GeneralRe: SQL Advice needed Pin
Graham Bradshaw23-Jul-08 10:41
Graham Bradshaw23-Jul-08 10:41 
GeneralRe: SQL Advice needed Pin
StevenWalsh23-Jul-08 10:49
StevenWalsh23-Jul-08 10:49 
GeneralRe: SQL Advice needed Pin
Pete O'Hanlon23-Jul-08 10:52
subeditorPete O'Hanlon23-Jul-08 10:52 
GeneralRe: SQL Advice needed Pin
GuyThiebaut23-Jul-08 11:28
professionalGuyThiebaut23-Jul-08 11:28 
GeneralRe: SQL Advice needed Pin
SomeGuyThatIsMe24-Jul-08 3:41
SomeGuyThatIsMe24-Jul-08 3:41 
GeneralRe: SQL Advice needed Pin
StevenWalsh24-Jul-08 5:40
StevenWalsh24-Jul-08 5:40 
GeneralRe: SQL Advice needed Pin
SomeGuyThatIsMe24-Jul-08 5:47
SomeGuyThatIsMe24-Jul-08 5:47 
not a problem, the disadvantage is that if you wanted to make it all contiguous you'd have to drop the DB, defrag the hdd then recreate the db larger than it was before. but that would require a decent amount of downtime(a few hours depending on your server) and enough storage some place to back up your current data so it could be restored. also on mass inserts, i've found it usefull to drop the indices and recreate them after the insert, if you can do it all at once. you should see a noticable performance improvement if you try that, doing a lot of inserts and updates to an index can(sometimes) corrupt it quite easily, thus slowing down performance for any action on that table, or anything that is related to that table.

Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

QuestionCreating Reports using DataSet Pin
Reality Strikes23-Jul-08 6:19
Reality Strikes23-Jul-08 6:19 
AnswerRe: Creating Reports using DataSet Pin
Wendelius23-Jul-08 7:20
mentorWendelius23-Jul-08 7:20 
GeneralRe: Creating Reports using DataSet Pin
Verghese25-Jul-08 5:57
Verghese25-Jul-08 5:57 
GeneralRe: Creating Reports using DataSet Pin
Wendelius25-Jul-08 10:37
mentorWendelius25-Jul-08 10:37 
QuestionSELECT command Pin
Reality Strikes23-Jul-08 5:33
Reality Strikes23-Jul-08 5:33 
AnswerRe: SELECT command Pin
Harvey Saayman23-Jul-08 5:46
Harvey Saayman23-Jul-08 5:46 
GeneralRe: SELECT command Pin
Reality Strikes23-Jul-08 6:00
Reality Strikes23-Jul-08 6:00 
GeneralRe: SELECT command Pin
Harvey Saayman23-Jul-08 6:57
Harvey Saayman23-Jul-08 6:57 
QuestionAttaching database Pin
hadad22-Jul-08 22:37
hadad22-Jul-08 22:37 
AnswerRe: Attaching database Pin
Colin Angus Mackay23-Jul-08 4:34
Colin Angus Mackay23-Jul-08 4:34 
AnswerRe: Attaching database Pin
Vimalsoft(Pty) Ltd23-Jul-08 6:58
professionalVimalsoft(Pty) Ltd23-Jul-08 6:58 
Questionsql server data transferring?? Pin
Dotnetkanna22-Jul-08 22:34
Dotnetkanna22-Jul-08 22:34 
QuestionMultiple processes with the same ID Pin
JacquesDP22-Jul-08 22:05
JacquesDP22-Jul-08 22:05 
AnswerRe: Multiple processes with the same ID Pin
Wendelius23-Jul-08 7:03
mentorWendelius23-Jul-08 7:03 
QuestionRe: Multiple processes with the same ID Pin
JacquesDP23-Jul-08 19:18
JacquesDP23-Jul-08 19:18 
AnswerRe: Multiple processes with the same ID Pin
Wendelius23-Jul-08 19:43
mentorWendelius23-Jul-08 19:43 
GeneralRe: Multiple processes with the same ID Pin
JacquesDP23-Jul-08 19:47
JacquesDP23-Jul-08 19:47 

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.