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...
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...
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 separate article to cover the bases....
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...
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 also know how to do bulk inserts...
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...
