Ir para o conteúdoIr para a pasta
      employer cover photo
      employer logo
      employer logo

      Greenway Health

      Parte da empresa Vista Equity Partners

      Empresa engajada

      Entrevista do cargo de SQL Developer da empresa Greenway Health

      Pergunta de entrevista da empresa Greenway Health

      Entrevista para SQL Developer

      What's the difference between TRUNCATE and DELETE

      Respostas da entrevista

      Sigiloso

      20 de jun. de 2017

      Both delete the data but Delete is a DML command can roll back but Truncate is a DDL command and don’t roll back and faster than DML

      Sigiloso

      7 de mar. de 2012

      one gets logged, the other doesn't so you have your performance hit. Need elevated permissions i.e. dbo for TRUNCATE

      1
      Buscas relacionadas: Avaliações da empresa Greenway Health | Vagas da empresa Greenway Health | Salários da empresa Greenway Health | Benefícios da empresa Greenway Health
      Entrevistas da empresa Greenway Health