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...
SQL Date Format: How to Handle It the Smart Way
Thanks to the diversity of cultures on Earth, we have a variety of date formats. For numeric dates, we have month-day-year,...
SQL CASE: Know and Avoid 3 Lesser-Known Hassles
SQL CASE? Piece of cake! Really? Not until you bump into 3 troublesome issues that can cause runtime errors and slow performance. If you...
Query Optimization Techniques in SQL Server: 5 Best Practices to Boost Queries Performance
What is query optimization in SQL Server? It’s a big topic. Each technique or problem needs a...
SQL FOREIGN KEY CONSTRAINT: The Ultimate, Easy Guide for Newbies
Newbie? Then an SQL foreign key may be foreign to you. You may have heard different opinions about SQL foreign keys. If you haven’t, soon...
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 proceeding to the MySQL DELETE statement....
How to Avoid Inserting Duplicate Records in SQL INSERT Query (5 Easy Ways)
You probably know how to insert records into a table using single or multiple VALUES clauses. You...
5 No-Hassle Tips to Use SQL UPDATE Statement with JOIN
“Oops! My bad.” How many times did you say this after an SQL UPDATE had gone wrong? The thing is, if you aren’t...
22 Different T-SQL Indexes Examples to Warp Speed Your Queries
Indexing the database tables is one of the ways to up your game in tuning queries. How do you do it? Today’s post will give you 22 SQL...
Top 5 Facts to Find and Replace SQL Texts in SQL Server with REPLACE Function
Today’s code editors and word processors come with a search and replace feature. It is...