Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • Reply To: How to Delete Large Amounts of Data

    Here is what I have done in the past:

    SELECT TOP (50000) * 
    INTO tmpEvt 
    FROM [dbo].TblStatus order by ID DESC

    TRUNCATE TABLE [dbo].TblStatus

    SET IDENTITY_INSERT [MyDB].[dbo].TblStatus ON
    GO
    INSERT INTO [MyDB].[dbo].TblStatus...

    October 15, 2021 at 12:27 pm

    #3940867

  • RE: Do you check your backups?

    Regarding the cost, don't ask if you can afford it, ask if you can afford not to
    Cheers

    April 19, 2018 at 1:00 am

    #1987453

Viewing 2 posts - 1 through 2 (of 2 total)