Tag: t-sql

Getting Started with the SQL Server T-SQL CASE Expression Statement

T-SQL

SQL Server CASE expression is very useful in returning an output based on some conditional matching...
Read More

SQL Server Primary Key

SQL Server

Across all major RDBMS products, Primary Key in SQL constraints has a vital role. They identify the records present in a table uniquely....
Read More

Overview of T-SQL PRINT Statement

Database development, Statements

PRINT statements are crucial in any programming language. They will allow the routine or program that you are running to dump some type of...
Read More

SQL Stuff Function

Database development, Statements

The main idea around the SQL Server function called STUFF is concatenating multiple columns into a...
Read More

Managing your MS SQL Replication

Database administation, Transaction Log

Replication is one of the oldest technologies on MS SQL Server, loved by every database administrator. It is a great and reliable...
Read More

Clustered and Non Clustered Index: 7 Top Points Explained

Database development, Indexes • One Comment

Indexes are speed-boosters in SQL databases. They can be clustered or non-clustered. But what does it mean and where should you apply...
Read More

MySQL UPDATE: Top 5 Tips for T-SQL Developers

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

Are you adding MySQL to your list of database skillsets? Then MySQL UPDATE statement is one of the...
Read More

In memory Tables (OLTP) in Microsoft SQL Server Databases with Examples

Database administation, Memory Optimization • 2 Comments

What if 1 second of a transaction process is too long? You can tune your queries. But what if it’s not enough, can you still step up...
Read More

Understanding DROP TABLE IF EXISTS SQL Statement

Database development, Statements

The T SQL DROP TABLE IF EXISTS statement is used to drop existing database objects. In this article, we are going to study the various use...
Read More

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

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

Our journey to MySQL started with CREATE TABLE followed by INSERT. Today, we are...
Read More
Close