Database development

SQL Server Triggers – Part 2 DDL & LOGON Triggers

Database development, Triggers

In SQL Server, triggers are database objects which will get executed whenever a triggering event...
Read More

SQL Server Triggers: DML Triggers

Database development, Triggers

In SQL Server, triggers are database objects which get executed whenever a triggering event happens on the database or server. Triggers...
Read More

Drop Temp Table in SQL Server and PostgreSQL

Database development, Statements, Tables

This article explains different ways to drop the temp table in SQL Server and PostgreSQL. As the name suggests, temporary tables are used...
Read More

What is SQL Server? (Definition, Versions, Editions)

Database administation, Database development

Excited? That’s how it feels to learn a new skill on your first day. It can also feel a bit...
Read More

The Easy and Practical SQL Server Tutorial for Beginners

Database development

Introduction to Our SQL Server Tutorial for Beginners Hello, budding SQL Server enthusiast! CodingSight would like to focus on you, the...
Read More

How to Use SQL Server T-SQL Function SUM: 5 Use Cases

Database development, Statements

The T-SQL SUM function is one of the fundamental functions. Its purpose is to calculate the sum of all values in the specified column –...
Read More

SQL Server Resumable Index: Is it good for you?

Database development, Indexes

SQL 2017 introduced the ability to pause and resume index rebuild operations during database...
Read More

SQL SELECT DISTINCT: Performance Best Practices

Database development, Statements

Is SQL DISTINCT good (or bad) when you need to remove duplicates in results? Some say it’s good and add DISTINCT when...
Read More

SQL OR Statement: The Basics

Database development, Statements

Now and then, you need to create a complex SQL query using multiple statements together. While these query types can be tedious to create,...
Read More

How to Use SQL SUM Function

Database development, Statements

SQL is a powerful and widely-used programming language for data storage, retrieval, and...
Read More
Close