Getting Started with the SQL Server T-SQL CASE Expression Statement
SQL Server CASE expression is very useful in returning an output based on some conditional matching...
SQL Server Primary Key
Across all major RDBMS products, Primary Key in SQL constraints has a vital role. They identify the records present in a table uniquely....
Overview of T-SQL PRINT Statement
PRINT statements are crucial in any programming language. They will allow the routine or program that you are running to dump some type of...
SQL Stuff Function
The main idea around the SQL Server function called STUFF is concatenating multiple columns into a...
SQL Server Replication Monitor: Scripts for Checking Replication Status
Replication is one of the oldest technologies on MS SQL Server, loved by every database administrator. It is a great and reliable...
Clustered and Non Clustered Index: 7 Top Points Explained
Indexes are speed-boosters in SQL databases. They can be clustered or non-clustered. But what does it mean and where should you apply...
MySQL UPDATE: Top 5 Tips for T-SQL Developers
Are you adding MySQL to your list of database skillsets? Then MySQL UPDATE statement is one of the...
In memory Tables (OLTP) in Microsoft SQL Server Databases with Examples
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...
Understanding DROP TABLE IF EXISTS SQL Statement
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...
TOP 5 MySQL Delete Syntax with Tips for T-SQL Developers
Our journey to MySQL started with CREATE TABLE followed by INSERT. Today, we are...
