No announcements
Found 738209 threads
-
0 VotesDelete Vs Truncate
PS.Shakeer Hussain Hyderabad Man... topic is DELETE vs TRUNCATE... not DROP vs TRUNCATE AND... ...Answered | 18 Replies | 7279 Views | Created by DoolinDalton - Monday, September 20, 2010 5:32 PM | Last reply by DoolinDalton - Tuesday, September 21, 2010 2:00 PM
-
0 Votes
Truncate Vs Delete
As an alternative , I may suggest to move (insert into) the data for 2013 (you can use TABLOCK hint) and then issue TRUNCATE command on the table , now that you can rename ...Answered | 8 Replies | 1312 Views | Created by Aniruddha Thengadi - Saturday, January 31, 2015 12:48 PM | Last reply by Uri Dimant - Sunday, February 1, 2015 3:07 PM -
0 Votes
Deleting Records using Truncate
Other option is to: 1. create new empty table similar to current 2. insert data you wish to not delete to the new table 3. use alter ...Answered | 6 Replies | 1839 Views | Created by Deepshika - Saturday, March 23, 2013 5:32 AM | Last reply by Kalman Toth - Saturday, March 23, 2013 11:00 AM -
3 Votes
IDENTITY Reseed with Delete Vs Truncate
If no rows have been inserted into the table since the table was created, or if all rows have been removed by using the TRUNCATE TABLE statement, the first row inserted after you run DBCC ...Answered | 2 Replies | 12525 Views | Created by Jayakumaur (JK) - Tuesday, March 25, 2014 10:42 AM | Last reply by Tom Phillips - Tuesday, March 25, 2014 1:50 PM -
0 Votes
Deletion of records using truncate
Hi Deepshikha, You cannot specify any WHERE clause with TRUNCATE command.Answered | 4 Replies | 1226 Views | Created by Deepshika - Tuesday, March 12, 2013 11:07 AM | Last reply by Papy Normand - Tuesday, March 12, 2013 5:27 PM -
3 Votes
Difference between Delete and Truncate
Truncate operation doesn't log row by row (like a delete does) it only logs information about the pages that were deallocated and so the amount of logging for ...Answered | 6 Replies | 10379 Views | Created by Vasavi Machina - Sunday, March 7, 2010 4:53 PM | Last reply by Manjunath C Bhat - Wednesday, March 21, 2012 7:59 AM -
0 Votes
Difference between truncate and delete
thanks..can i use the your example and replace DELETE instead of TRUNCATE to see the effect?..Answered | 12 Replies | 6928 Views | Created by senthilkr - Friday, September 14, 2007 7:45 AM | Last reply by prashant_victory - Wednesday, November 28, 2007 5:40 AM -
0 Votes
executing a truncate runs a delete from?
Any truncate issued to SQL Server that uses an ODBC connection is run by Informatica as a delete from .Answered | 5 Replies | 5764 Views | Created by deescott - Wednesday, July 21, 2010 1:42 PM | Last reply by deescott - Monday, August 16, 2010 8:40 PM -
0 Votes
difference between delete and truncate in space of data and logged
WHY truncate DDL command not DML DDL treat with structure not data but truncate treat with data not structureAnswered | 7 Replies | 4076 Views | Created by eng-ahmed-salah - Friday, October 21, 2016 3:44 PM | Last reply by Shanky_621 - Friday, October 21, 2016 7:17 PM -
0 Votes
Truncate
Will the truncate apply to secondaries in logshipping and mirroring?Answered | 7 Replies | 1598 Views | Created by Surya.chamala - Sunday, February 2, 2014 7:16 AM | Last reply by Surya.chamala - Tuesday, October 28, 2014 4:40 PM -
1 Votes
BCP in While Loop (Truncate / Delete)
This means that once you have deleted the rows, the are locks on the table.Answered | 2 Replies | 8363 Views | Created by sqldba20 - Friday, November 9, 2012 12:30 AM | Last reply by Erland Sommarskog - Tuesday, November 13, 2012 4:40 PM -
3 Votes
Can Truncate be rolled back like the delete command.
HI Sam, You should also read Kalen's blog article on this topic , she has given a clear and comprehensive insight on this ...Answered | 6 Replies | 11997 Views | Created by sams6 - Tuesday, January 4, 2011 6:41 AM | Last reply by Lekss - Tuesday, January 4, 2011 8:02 AM -
0 Votes
Delete or Truncate The Data Based on Date Column
I think you have 2 options, If you do not want make changes to package then write a stored procedure that will delete records from the table ,you can use the ...Answered | 2 Replies | 3779 Views | Created by cmk1 - Thursday, August 16, 2012 1:23 AM | Last reply by Yogisha Bhat - Thursday, August 16, 2012 4:35 AM -
0 Votes
Truncate or delete Access table using SSIS
So please use the correct data provider to connect to the Access data source, then use the query below to delete the access table within a Execute SQL ...Answered | 5 Replies | 3971 Views | Created by 1234alex - Friday, September 4, 2015 7:56 PM | Last reply by 1234alex - Wednesday, September 9, 2015 4:16 AM -
2 Votes
Can I stop a truncate job?
Both DELETE and TRUNCATE are logged.Answered | 10 Replies | 795 Views | Created by Baron164 - Tuesday, February 23, 2016 3:14 PM | Last reply by Baron164 - Wednesday, February 24, 2016 7:53 PM -
0 Votes
Logon and Truncate
Truncate is like Deleting all records from a table.Answered | 3 Replies | 3728 Views | Created by subu999 - Thursday, April 5, 2012 9:56 AM | Last reply by Sunil Gure - Thursday, April 5, 2012 11:54 AM -
0 Votes
SSMA generates TRUNCATE TABLE statements for data migration, want DELETE instead
Based on my search, there isn’t a feature or project setting in SQL Server Migration Assistant (SSMA) for access to generate DELETE statement, could you manually ...Answered | 1 Replies | 1822 Views | Created by G Britton - Tuesday, March 8, 2016 8:38 PM | Last reply by copu - Friday, March 11, 2016 10:30 AM -
1 Votes
Urgently need to recover deleted/truncated data from tables
Nope - as you have no backups you are pretty much stuffed and if you have deleted a client's data that you can't recover then you could be in pretty deep trouble!Answered | 6 Replies | 3201 Views | Created by cse_supriya - Thursday, November 10, 2016 3:00 AM | Last reply by Martin.Cairney - Thursday, November 10, 2016 11:57 PM -
2 Votes
Truncate command
If I am going to delete the rows, as the rowcount is huge it would flood the tlog.Answered | 5 Replies | 1593 Views | Created by SSG92 - Friday, November 22, 2019 8:32 AM | Last reply by Dedmon Dai - Monday, November 25, 2019 6:19 AM -
0 Votes
Can't select, delete, truncate, or drop table in Azure SQL DB
After the scale I could read/delete/etc from the db instantly.Answered | 2 Replies | 2417 Views | Created by Kayhustle11 - Monday, November 23, 2015 10:23 PM | Last reply by Kayhustle11 - Wednesday, November 25, 2015 7:15 AM - Items 1 to 20 of 738209 Next ›
No announcements
