Click here to Skip to main content
15,507,526 members
Home / Discussions / Database
   

Database

 
GeneralRe: while poop in stored procedure Pin
Joe10-Oct-07 21:04
Joe10-Oct-07 21:04 
GeneralRe: while poop in stored procedure Pin
Sonia Gupta10-Oct-07 21:27
Sonia Gupta10-Oct-07 21:27 
GeneralRe: while poop in stored procedure Pin
N a v a n e e t h10-Oct-07 23:54
N a v a n e e t h10-Oct-07 23:54 
GeneralRe: while poop in stored procedure Pin
Sonia Gupta11-Oct-07 0:43
Sonia Gupta11-Oct-07 0:43 
GeneralRe: while poop in stored procedure Pin
N a v a n e e t h11-Oct-07 1:39
N a v a n e e t h11-Oct-07 1:39 
GeneralRe: while poop in stored procedure Pin
joemonvarghese10-Oct-07 20:48
joemonvarghese10-Oct-07 20:48 
Questionan intersting sql problem Pin
richardye10-Oct-07 19:46
richardye10-Oct-07 19:46 
AnswerRe: an intersting sql problem Pin
GuyThiebaut10-Oct-07 23:53
professionalGuyThiebaut10-Oct-07 23:53 
richardye wrote:
As there isn't much memory can be used, how to deal with it perfectly (both in time and in space)?


What is going to happen when you delete all of those records is that the transaction log is going to grow.

Regarding disk space(I take it you mean disk space rather than memory?):
Backup the transaction log to clear it out of pending transactions first.
You will then need to shrink the transaction log.
Run your script to delete the records.
Then straightaway backup the transaction log and shrink it again.
This is the only way I can think of to keep disk space usage at a minimum.

Regarding speed:
All I can suggest is that you do all of this out of hours when nobody else is using the database.
If anybody else is accessing the table you are deleting from there is always the chance that you could get a lock, for a period of time, or even a deadlock.







You always pass failure on the way to success.

AnswerHow to shrink a transaction log - and make sure that it actually shrinks. Pin
GuyThiebaut11-Oct-07 0:04
professionalGuyThiebaut11-Oct-07 0:04 
QuestionSQL Server Replication Pin
Anilkumar K V10-Oct-07 19:10
Anilkumar K V10-Oct-07 19:10 
QuestionProblem Regarding trigger Pin
Aavesh Agarwal10-Oct-07 18:52
Aavesh Agarwal10-Oct-07 18:52 
AnswerRe: Problem Regarding trigger Pin
joemonvarghese10-Oct-07 20:29
joemonvarghese10-Oct-07 20:29 
GeneralRe: Problem Regarding trigger Pin
Aavesh Agarwal10-Oct-07 21:15
Aavesh Agarwal10-Oct-07 21:15 
QuestionTrying to figure out how to secure the db better. Starting with:Limit user access. Pin
foolios10-Oct-07 16:46
foolios10-Oct-07 16:46 
Questionmultiple threads accesing msAccess Pin
dsovino10-Oct-07 15:42
dsovino10-Oct-07 15:42 
Questionhow can i insert mpeg files to DB? Pin
ebtihal10-Oct-07 14:25
ebtihal10-Oct-07 14:25 
AnswerRe: how can i insert mpeg files to DB? Pin
Christian Graus10-Oct-07 15:07
mveChristian Graus10-Oct-07 15:07 
GeneralRe: how can i insert mpeg files to DB? Pin
Vidhya Sagar10-Oct-07 17:27
Vidhya Sagar10-Oct-07 17:27 
QuestionTable Column Decimal Value Pin
Brendan Vogt10-Oct-07 6:22
Brendan Vogt10-Oct-07 6:22 
AnswerRe: Table Column Decimal Value Pin
pmarfleet10-Oct-07 6:36
pmarfleet10-Oct-07 6:36 
Questiona problem about m_pConnection->Execute Pin
nibabug10-Oct-07 5:31
nibabug10-Oct-07 5:31 
QuestionBulk insert - Fewer fields than in DB Pin
clint198210-Oct-07 5:17
clint198210-Oct-07 5:17 
GeneralRe: Bulk insert - Fewer fields than in DB Pin
PIEBALDconsult10-Oct-07 7:30
professionalPIEBALDconsult10-Oct-07 7:30 
AnswerRe: Bulk insert - Fewer fields than in DB Pin
GuyThiebaut10-Oct-07 8:01
professionalGuyThiebaut10-Oct-07 8:01 
QuestionCalling reports from server logged in user wise Pin
MSinha10-Oct-07 4:50
MSinha10-Oct-07 4:50 

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.