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 […]
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 […]
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 […]
In TSQL Tutorial 16, l discussed and implemented the various types of user defined stored procedures. I’m going to continue the discussion and probably end my discussion about stored procedures in this tutorial with some very important things to know about stored procedures apart from just writing the query to create them. In the last […]