The transaction finished in 10 hours. Is that normal for deleting 14 million rows? How do you use (raiserror ... 0, 1... with log) and dirty (unlock) reads to show the progress of the execusion? Thank you, Mark.
2003-07-30
Very good!! You forgot the HR director Mr Pay_Peanuts_Get_Monkeys
2003-07-30
SQLBill, QUOTE: Not all the numbers are integers UNQUOTE. I meant not all values are integer values (1,2,3 ...). There will be 1.15, 2.36 ... If 1.15 as varchar cannot be converted to 1.15 decimal how can I get 1.15 into a numeric datatype without losing precision? Thanks for your help!
2003-07-29
1 reads
quote: Have you considered importing it into Access, splitting the tables, and bringing it back into SQL Server? Yes but the amount of records is absolutely huge and MsAccess can't take it !
2003-07-22
2003-07-15
1 reads
Ritch, I guess your intention was to provide a link, right? could you please do that. Thans
2003-06-26
The script below will solve your problem,it runs for bot sql 7.0 an sql 2000. -- Caution : database compatibility level must be 7.0 or higher .. dbcc shrinkfile ( [Logical Log File Name], truncateonly ) backup log [Logical Database Name] with truncate_only GO if exists ( select * from sysobjects where name ='tmp_00000000000001a') drop […]
2003-06-19
1 reads
I actually meant : sp_dropuser 'sa' Server: Msg 15008, Level 16, State 1, Procedure sp_dropuser, Line 12 User 'sa' does not exist in the current database. Thanks.
2003-06-13
What would be nice is you could alias common phrases. eg: Declare FU*K_OFF = GOTO Err_Handler If your code you could then have: ON ERROR FU*K_OFF Cheers, Crispin
2003-06-13
1 reads
You used some memory in the process due to the procedure and buffer caches. However that memory will be recovered as needed by SQL or the OS at some point. Most likely you make see SQL take a bit more memory and not free but that internally SQL will reutilize as needs be.
2003-06-11
2 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers