Basic Logics · Data Analysis · Data Management · Data Migrations · Real Scenario Logic's

To Find Fill Rate in a Table on both AZURE and On-Premise – Key Metric in Data Analysis

Introduction Knowing Fill Rate is one of the essential tasks in Data Analysis/Management and Migration Processes. It helps us to take Business Decisions effectively. In this post, will see how to find the Fill rate in a table using SQL Queries that is Applicable for both AZURE and On-Premises... What is meant by Fill Rate?… Continue reading To Find Fill Rate in a Table on both AZURE and On-Premise – Key Metric in Data Analysis

Advertisement
Alternatives · Basic Logics · Real Scenario Logic's · String Functions · String Manipulation

To Remove Multiple and Duplicate Spaces to Single Space in SQL Server

In this blog post, we would see some of the easy methods to remove Multiple as well as Duplicate Spaces to Single Space using T-SQL in SQL Server like below. METHOD 1 - WHILE LOOP AND REPLACE By Using WHILE Loop, we can check the occurrences of double spaces, as Loop Condition.Till the occurrence (Loop)… Continue reading To Remove Multiple and Duplicate Spaces to Single Space in SQL Server

Alternatives · Basic Logics

Common Alternatives to IF ELSE Logic in SQL Server with Simple Example

Below are the Common Alternatives of IF ELSE Logic in SQL Server that was given with simple example. IF ELSE LOGIC SYNTAX IF Boolean_expression { sql_statement | statement_block } [ ELSE { sql_statement | statement_block } ] --ELSE Block is OPTIONAL SQL QUERY WITH SIMPLE EXAMPLE --IF ELSE LOGIC IF 1>0 SELECT 'True' AS RESULT;… Continue reading Common Alternatives to IF ELSE Logic in SQL Server with Simple Example

Basic Logics · Keyboard Shortcuts · Real Scenario Logic's

Refresh, Enable, Disable IntelliSense Feature in SSMS (SQL Server Management Studio)

Introduction Microsoft IntelliSense is one of the feature that is available in the text editor of SSMS (SQL Server Management Studio).It would reduce our Typings and provide us quick access to syntax info. In this blogpost, we are going to know how to Refresh IntelliSense when it shows 'Error with red line' , and Enable… Continue reading Refresh, Enable, Disable IntelliSense Feature in SSMS (SQL Server Management Studio)

Basic Logics · Real Scenario Logic's · Uncategorized

To Remove IDENTITY property from a column in a table by handling Foreign key relationships in both AZURE and On-premises

If we want to remove the IDENTITY property from a column in a Table, but at the same time if we want to keep the table data as it is. Please follow the below steps with examples(images also attached for ref). Sample Table Creation and Data Population Script --PARENT TABLE CREATE TABLE dbo.[TestEmp] ( TestEmp_Key… Continue reading To Remove IDENTITY property from a column in a table by handling Foreign key relationships in both AZURE and On-premises