Skip to main content
{coding}Sight
  • SQL Server
  • .NET
  • C#
  • Azure
  • Oracle
  • PostgreSQL
  • About

Tag: truncate table

Difference Between DELETE and TRUNCATE Table in SQL Server

January 26, 2021January 26, 2021 Nisarg Upadhyay Leave a comment

Many articles have been written to describe the difference between the DELETE and TRUNCATE statements. Moreover, it is one of the most common questions during job interviews. Both statements remove the data from the table. However, there are differences too.

This article will focus on these differences and illustrate them with practical examples.

Read More

Understanding MySQL TRUNCATE TABLE by Practical Examples

January 5, 2021January 19, 2021 Nisarg Upadhyay Leave a comment

MySQL TRUNCATE TABLE statement is a DDL statement used for removing all records from the MySQL table. When we run this command, it drops the existing table first and then creates a new table using the table definition. The query execution sequence of the TRUNCATE TABLE command is DROP TABLE and CREATE TABLE.

Read More

Workplace Encounters: Reclaiming Space from an Oversized Database

August 21, 2020October 7, 2020 Kenneth Igiri Leave a comment

INTRODUCTION

This document records steps, scripts, and ideology behind the maintenance performed on a production database between 22nd April 2015 and 23rd April 2015. The details are specific to an application, but the principles may be useful to others in need of doing similar operations in production.

Read More

SIGN UP FOR CODINGSIGHT DIGEST

Subscribe to our digest to get SQL Server industry insides!

Most popular posts

  • Introduction to Temporary Tables in SQL Server
  • Grouping Data using the OVER and PARTITION BY Functions
  • Calculating Running Total with OVER Clause and PARTITION BY Clause in SQL Server
  • 10 Best MySQL GUI Tools
  • Similarities and Differences among RANK, DENSE_RANK and ROW_NUMBER Functions
  • Methods to Rank Rows in SQL Server: ROW_NUMBER(), RANK(), DENSE_RANK() and NTILE()
  • Passing Data table as Parameter to Stored Procedures
  • Git Branching Naming Convention: Best Practices
Exclusively for the Codingsight readers, Devart offers a 10% discount on all product license purchases!
Simply use a CODINGSIGHT coupon code.

Become an author

What does it take to start writing for us? Learn more

Read what our contributors say about us

Tags

.net .net framework Always On asp.net core azure azure sql c# database administration database backup database security design patterns docker entity framework execution plan failover cluster instance full-text search indexes json linked server linq linux Microsoft Azure oracle performance query performance sql sql constraints sql database sql functions sql operator sql server sql server 2016 sql server 2017 ssis ssms t-sql t-sql queries t-sql statements tdd tips and tricks tools transaction log unit test visual studio windows

follow us on social networks

Devart SQL Complete Banner

Jooble Banner
  • SQL Server
  • .NET
  • C#
  • Azure
  • Oracle
  • PostgreSQL
  • About
sparkling Theme by Colorlib Powered by WordPress

Subscribe to our newsletter.

Weekly coding tips right in your inbox

✓ No spam     ✓ 100% Great content, always