Reading Time: < 1 minute“If I have a query that I run frequently, why should I save it as a View in the database instead of just simply saving it as a .SQL script file and running the query when I need it?” There are two main benefits to saving your query as a Continue Reading
Table Expressions
Can we create indexes in table variables? YES WE CAN!
Reading Time: 2 minutesIt is absolutely possible to create indexes within a table variable in Microsoft SQL Server. The key is to add the indexes as part of the table variable definition Take a look at this regular table definition (which does not have any indexes placed on it yet): CREATE TABLE Books Continue Reading
Updatable View in SQL Server: A How-To Guide
Reading Time: 10 minutesA proper understanding of Views in SQL Server will definitely help you become a better database developer. Views allow us to basically save a query as an object in the database, and make it very easy to run the query with simple commands. But what if we want to make Continue Reading
Top 6 tools you should know for writing AWESOME Select statements
Reading Time: 13 minutesAs a database professional, you will be asked to come up with SELECT statements to pull needed information in a meaningful and accurate way. Sometimes you will need to review other SELECT statements written by other people, too. Maybe those queries have a problem which is causing it to pull Continue Reading
Common Table Expression (CTE) in SQL: Everything you need to know
Reading Time: 8 minutesCommon Table Expressions (CTE’s) are a very useful tool available to us when querying databases in Microsoft SQL Server. CTE’s can help you gather the information you want quickly without needing to write much code, or persist an object in the database. Common Table Expressions are just one type of Continue Reading
Derived Table in SQL Server: Everything you need to know
Reading Time: 9 minutesWhen learning about table expressions, the first and most simple table expressions you can learn is the Derived Table. They can help you gather the information you want quickly without needing to write much code. Derived Tables are just one type of table expression we have available to us in Continue Reading
SQL Server Table Expressions: The Ultimate Guide for Beginners
Reading Time: 10 minutesThere are several different kinds of table expressions you need to be aware of when learning to query and develop SQL Server databases. Each kind of table expression has it’s own strengths and weaknesses, and it is important for you to understand those strengths and weaknesses so you know which Continue Reading
Inline Table Valued Function: The Ultimate Guide for Beginners
Reading Time: 9 minutesIn 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
SQL Server Views: A Guide for Beginners
Reading Time: 10 minutesA 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