Handling the NULL Values Effectively with the SQL COALESCE Function for Beginners
This article aims to help beginners understand the basics of the T-SQL COALESCE function and its...
Your Ultimate Guide to SQL Joins: OUTER JOIN – Part 2
Outer join is at the center stage today. And this is part 2 of your ultimate guide to SQL joins. If you missed part 1, here’s the...
Views in SQL Server
Introduction A view in SQL Server is a virtual table-like structure based on the result-set of an SQL statement. On the surface, a view is...
How CTE Can Aid In Writing Complex, Powerful Queries: A Performance Perspective
We often see poorly written complex SQL queries running against a table or tables in databases....
Using CASE Expressions in SQL Server
Introduction CASE Expressions in SQL Server are used for the column values substitution to present the result sets in a particular fashion...
Top Answers to 5 Burning Questions on COALESCE Function in SQL Server
How cool is COALESCE function in SQL? It’s cool enough to be so important to me. And I’ll be more than happy to hire a new guy who...
SQL Server Inner Join Basics with Examples
Introduction T-SQL allows us to combine records from more than one table and return them as a...
SQL Server Indexes Management Using Index Manager for SQL Server
SQL Server Index Overview When talking about SQL Server performance tuning and queries enhancement, the first thing to consider is the SQL...
How To Create SQL Trace To Capture SQL Server Events
Facing an SQL Server performance issue, you need to identify the source of that performance problem fast. Therefore, a tool for tracking...
Configure SQL Jobs in SQL Server using T-SQL
SQL Server Agent is a component used for the database tasks automation. For instance, we need to...
