Tag: t-sql

Overview of T-SQL PRINT Statement

09:57 Database development, Statements

PRINT statements are crucial in any programming language. They will allow the routine or program...
Read More

T-SQL Stuff Command

08:45 Database development, Statements

The main idea around the SQL Server function called STUFF is concatenating multiple columns into a single column with more flexibility than...
Read More

Managing your MS SQL Replication

10:54 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

12:46 Database development, Indexes • One Comment

Indexes are speed-boosters in SQL databases. They can be clustered or non-clustered. But what...
Read More

MySQL UPDATE: Top 5 Tips for T-SQL Developers

10:48 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 commands you need to learn. We are...
Read More

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

14:44 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

15:08 Database development, Statements

The DROP TABLE IF EXISTS statement is used to drop existing database objects. When we create a...
Read More

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

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

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

How to Rename a Table Name in SQL Server

10:56 Database development, SSMS, Stored Procedures, Tables

One of the most critical database administrator’s duties is managing database objects. For instance, the application logic changes,...
Read More

Top 5 Facts to Find and Replace SQL Texts in SQL Server with REPLACE Function

10:07 Database development, Statements, Work with data

Today’s code editors and word processors come with a search and replace feature. It is...
Read More