Database development

Create and Configure Oracle Linked Server in SQL Server

Database development

This article explains the step-by-step process of creating and configuring a linked server between...
Read More

TOP 5 MySQL Delete Syntax with Tips for T-SQL Developers

Database development, Languages & Coding, MySQL, Statements, T-SQL

Our journey to MySQL started with CREATE TABLE followed by INSERT. Today, we are proceeding to the MySQL DELETE statement....
Read More

4 Ways to Count Rows in SQL Server Table with Pros and Cons

Database development, Statements, Tables

Recently, I was working on a database performance improvement project. One stored procedure there was causing issues. In its code, a query...
Read More

How to Avoid Inserting Duplicate Records in SQL INSERT Query (5 Easy Ways)

Database development, Statements

You probably know how to insert records into a table using single or multiple VALUES clauses. You...
Read More

5 No-Hassle Tips to Use SQL UPDATE Statement with JOIN

Database development, Statements

“Oops! My bad.” How many times did you say this after an SQL UPDATE had gone wrong? The thing is, if you aren’t...
Read More

MIN and MAX Aggregate Functions in SQL Server

Database development, Statements

SQL Server Functions In database systems in general and in SQL Server in particular, functions are pieces of code that take zero or one...
Read More

22 Different T-SQL Indexes Examples to Warp Speed Your Queries

Database administration, Database development, Indexes, Languages & Coding, Performance Tuning, T-SQL

Indexing the database tables is one of the ways to up your game in tuning queries. How do you do...
Read More

Understanding DROP TABLE Statement in SQL Server

Database development, Statements, Tables

The SQL Server DROP TABLE statement serves to drop the table from the database. This article will explain some use scenarios and illustrate...
Read More

Basics of SQL Server ALTER TABLE Statement

Database development, Statements, Tables

This article focuses on the ALTER TABLE statement in SQL Server and the following tasks on SQL Server tables: Add one or multiple columns...
Read More

SQL Reference Table: How to Create and Write Basic Queries

Database development, Statements, Tables

This article will focus on writing SQL queries against the database reference table with a fairly...
Read More
Close