Learn With Sundar

Get Started

  • Aggregate Functions in SQL Server

    Introduction Aggregate Functions are used to return a single value, which is calculated from multiple values in a column. Aggregate functions are build in SQL Server functions which are applied to set of records and we get summarized data. Aggregate Functions The following are the set of built in Aggregate functions in SQL Server, AVG()…

  • Retrieve Unsaved SQL Query Scripts

    Introduction In this article, we will have a look how to retrieve the Unsaved SQL Query using T-SQL. Sometimes, we may close the Query Window or SSMS accidentally without saving. This may cause to loss the Queries which we where working. Retrieve Unsaved SQL Query using T-SQL Statement Apply the below T-SQL Statement in which…

  • Select Statement Execution Order In SQL Server

    Introduction We all can write the SELECT Statement in SQL Server. But how many of us know the execution order of SELECT statement query?. In this article, lets discuss how the SELECT statement is Executed or the in which order the Query is executed. Query Order Of Execution Lets take above SQL SELECT Statement Syntax…

  • System Databases in SQL Server

    Introduction In SSMS, we many of may noticed System Databases under the Database Folder. But how many of us knows its purpose?. In this article lets discuss about the System Databases in SQL Server. System Database There are five system databases, these databases are created while installing SQL Server. Master Model MSDB Tempdb Resource Master…

  • What is Database Normalization in SQL Server – MS SQL Server – Zero to Hero Query Master – Part 4

    What is Database Normalization Database normalization is the step by step process of organizing data to minimize data redundancy i.e. Data duplication which in turn ensures data consistency Normalization is a database design technique that reduces data redundancy and eliminates undesirable characteristics like Insertion, Update and Deletion Anomalies. Normalization rules divide larger tables into smaller…

  • Schema Comparisons using Visual Studio SQL Data Tools

    Introduction There are many occasions where we may need to compare the schema between two databases. For example, comparing Development and Production databases against each other, or comparing a database against a SQL Server Database project. Microsoft Visual Studio SQL Data Tools provides functionality that allows us to compare the structure of the database tables,…

Subscribe

Enter your email below to receive updates.