-
Power BI Basic Data Transformation Technique
Introduction When working in a large set of Data, definitely we cannot use the data as it is. We need to perform some refinements so that we can exactly look into the data in which we are interested. In Power BI, this process is called Data Transformation, which can be done in different ways. In…
-
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…
Subscribe
Enter your email below to receive updates.
