3 Methods to Rebuild All Indexes for All Tables with T-SQL in SQL Server Database
There are several methods of how to rebuild all indexes of all tables in SQL Server, among them:...
4 Ways to Count Rows in SQL Server Table with Pros and Cons
Recently, I was working on a database performance improvement project. One stored procedure there was causing issues. In its code, a query...
Understanding DROP TABLE Statement in SQL Server
The SQL Server DROP TABLE statement serves to drop the table from the database. This article will explain some use scenarios and illustrate...
Basics of SQL Server ALTER TABLE Statement
This article focuses on the ALTER TABLE statement in SQL Server and the following tasks on SQL...
SQL Reference Table: How to Create and Write Basic Queries
This article will focus on writing SQL queries against the database reference table with a fairly simple structure to understand and...
How to Rename a Table Name in SQL Server
One of the most critical database administrator’s duties is managing database objects. For instance, the application logic changes,...
SQL Server DELETE – Removing One or More Rows from a Table with Slightly Advanced Scenarios
The current article focuses on slightly advanced use of the DELETE statement to remove one or more...
SQL Server Delete Statement: How to Remove One or Multiply Rows from the Table
The right application of the DELETE statement for data removal is crucial, and it involves lots of issues. Still, there are standard...
CREATE TABLE MySQL vs T-SQL with Syntax Examples
Are you a T-SQL developer learning the basics of MySQL? Then, one of the things you might want to learn is MySQL CREATE TABLE statement....
Difference Between DELETE and TRUNCATE Table in SQL Server
Many articles have been written to describe the difference between the SQL DELETE and SQL TRUNCATE...
