TSQL Tutorial 20: Index

In this tutorial, l’ll be discussing one of the most used database objects for optimizing the performance of queries. Indexes are very important and every developer should know when to create it or not. They are DB objects that are used to optimize the performance of T-SQL queries by organizing data in a particular pattern in a […]

Read More

TSQL Tutorial 19:Views

I’ve been a little busy for the past week which made me fall behind most of the things l wanted to write on the Learning Blog. There are more features added to the site because I’m trying to do something bigger and impact the world a little better. In this tutorial, I’m going to discuss […]

Read More

TSQL Tutorial 18:User Defined Functions.

In the last tutorial, l discussed stored procedures. Stored procedures are used for implementing the complex logic of a business while functions are commonly used for specific tasks. Do not confuse a stored procedure for a function, also remember there are system functions which are provided by the SQL Server. There are lot of system […]

Read More