10 SP_EXECUTESQL Gotchas to Avoid for Better Dynamic SQL
Do you know how powerful a tool like dynamic SQL can be? Use it the wrong way, and you can allow...
FLOAT Data Type in SQL Server: A Practical Guide to Prevent Unexpected Mathematical Errors
Have you ever thought that SQL can be wrong in math? It sounds crazy. But if you’ve used the SQL FLOAT data type, you may have come...
SQL Data Types: 5 Worst Choices You Need to Stop Today
Do your choices of SQL server data types and their sizes matter? The answer lies in the result you got. Did your database balloon in a...
Easy Answers to 5 Vital Questions about Composite Index in SQL
Imagine you need to query a table with a WHERE clause on columns a, b, and c. Sometimes, you filter...
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 commands you need to learn. We are...
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, day-month-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...
