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...
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. Those queries make the time of execution...
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 single result set. This is achieved through...
Pivoting, Unpivoting, and Splitting Columns in Power BI Query Editor
For reference, Power BI is a data visualization and analytics software developed by Microsoft....
Searching for Database Objects and Table Data in SQL Server
If you are a SQL Server database administrator or developer, you need to frequently search for specific database objects the names of which...
How to Update SQL Server Statistics for Big Tables
In my previous article, I have briefly covered database statistics, its importance, and why statistics should be updated. Moreover, I have...
Switching Out Table Partitions in SQL Server: A Walkthrough
Introduction A few years ago we were tasked with a business requirement for card data in a specific...
Several Ways to Insert Split Delimited Strings in a Column
In this article, I will demonstrate several ways to split the delimited string and insert it in into a column of a table in SQL Server. You...
SQL Server Database Tables Export and Import Methods
When working as a SQL Server database administrator or developer, you cannot live in your isolated SQL Server world without communicating...
Advanced SQL: Insert output of the parameterized table-valued function in SQL table
In this article, I am going to demonstrate the following: How to insert the output of a...
