Reading Time: 12 minutes If you are planning on spending any time at all working with SQL Server, you should probably expect to encounter stored procedures very early in your career. Stored procedures are very common objects found in SQL Server databases. They are basically what we use to write programming logic within SQL Continue Reading
User Defined Functions in SQL Server: A Complete Guide
Reading Time: 11 minutes In this introduction tutorial, we will discuss one of the most common SQL Server objects you will see in your career working with SQL Server: User defined functions. There are three types of user defined functions in SQL Server: Scalar Valued Functions Inline Table Valued Functions Multi Statement Table Valued Continue Reading
Multi Statement Table Valued Function: The Ultimate Guide for Beginners
Reading Time: 12 minutes One of the most powerful tools available to us in Microsoft SQL Server is Multi Statement Table Valued Functions. These are user-defined functions similar to Scalar functions and Inline Table Valued functions. We use functions in SQL Server to run repeatable code very easily. Are you struggling to understand how Continue Reading
Inline Table Valued Function: The Ultimate Guide for Beginners
Reading Time: 9 minutes In this tutorial on SQL Server user defined functions, we will discuss Inline Table Valued Functions. User defined functions are an extremely common thing in Microsoft SQL Server. A solid understanding of user defined functions is crucial for anyone who is in the position of querying and developing SQL Server Continue Reading
Scalar Valued Function: The Ultimate Guide for Beginners
Reading Time: 10 minutes User defined functions are very common objects you will see and use when querying and developing SQL Server databases. It is very important that you know what they are and how they work. In this first lesson on SQL Server user defined functions, we will discuss Scalar Valued Functions. If Continue Reading
Nonclustered Index in SQL Server: A Beginner’s Guide
Reading Time: 10 minutes In this discussion, we’ll talk about the younger brother of the clustered index: The nonclustered index. In a separate discussion, we talked about how understanding and using clustered indexes is very helpful towards writing efficient queries in SQL Server. If you missed that discussion, you can find it here: Clustered Continue Reading
SQL Server Clustered Index: The Ultimate Guide for the Complete Beginner
Reading Time: 10 minutes Understanding how indexes work is a critical component to understanding how to write efficient queries in SQL Server. The first type of index you should know is the clustered index. We will discuss the following topics about clustered indexes in this tutorial: What is a clustered index? How does a Continue Reading
SQL Server Index INCLUDE: Explained with Examples
Reading Time: 9 minutes In this tutorial, we will discuss a common characteristic of nonclustered indexes: INCLUDED columns. If you missed the full discussion about nonclustered indexes, I suggest you read that first. Check it out here: Nonclustered Indexes: The Ultimate Guide for the Complete Beginner In this tutorial, we will answer the following Continue Reading
IDENTITY Column in SQL Server: Everything you need to know
Reading Time: 14 minutes The IDENTITY property is a very common property to see in SQL Server tables. It’s important to understand what it is, and how it can help you maintain data in your tables. In this tutorial, we will discuss everything you need to know about the IDENTITY property, including: 1. What Continue Reading
SQL Server Views: A Guide for Beginners
Reading Time: 10 minutes A very common object you will see in SQL Server databases are Views. It is important to know what a View is, how to create one, and how they can help your user experience. Views are part of the Top 6 tools you should know for writing AWESOME Select statements. Continue Reading