Learn With Sundar

Get Started

  • Python Packages in SQL Server – Get Started with SQL Server Machine Learning Services – Part 5

    Introduction When installing Machine Learning Services in SQL Server by default few Python Packages are installed. In this article, we will have a look on how to get those installed python package information. Python Packages When we choose Python as Machine Learning Service during installation, the following packages are installed in SQL Server, revoscalepy –…

  • Find Columns That Allows NULL In SQL Server

    Introduction The columns in a table, that allows NULL in a database sometimes can lead to performance issues. The Nullable columns may be one of the reason to lead query to performance bad. By making columns NOT NULL can help the query to perform well. In this article we will discuss a simple way to…

  • SQL Server Rank Functions

    Introduction As like an Aggregate functions, the Ranking functions will rank the values of specified field and categorize them according to their rank . Ranking functions are most commonly used to find the top records based on conditions, example, to find the top ranking students, top highest paid employees and etc. Ranking Functions There are…

  • T-SQL Query For Finding The Longest And Shortest names In A Table

    Introduction In SQL Server, we can find the Longest String Value and Shortest String Value from the same table. To find the longest and shortest values, there are many ways, but in this article, we will discuss some simplest ways. Disclaimer: From this article, I am not sharing these are the only efficient ways to…

  • MERGE Statement in SQL Server to Insert, Update, Delete Records

    Introduction In a single transaction (MERGE Statement) we can perform Insert, Update and Delete records on a existing table based on the result comparison between important columns with another table. Which also means we no longer needs to write multiple T-SQL statements to handle Insert, Update, Delete. MERGE Statements To perform MERGE, we need two…

  • Function to Calculate Simple Interest In SQL Server

    Introduction Whenever working in Financial Applications like Banking applications or financial modules in any ERP application we might have seen as Simple Interest. Usually we do those calculations in the programming application or else in the Frontend side and pass that calculated value to the database tables. But we can also do the same simple…

Subscribe

Enter your email below to receive updates.