SQL Server NEWID()
SQL Server NEWID() function is a system function that is used to generate a unique value of type uniqueidentifier.
Home » Archives for Pradeep Raturi »
Pradeep Raturi
I have 8+ years of working experience in Business Intelligence Data Modelling, Power BI, SQL Server, SSRS, SSIS, Azure Data Factory, Power Apps.
SQL SERVER @@IDENTITY
SQL Server @@IDENTITY function is a system function that is used to get the last IDENTITY value generated for any table with an identity column under the current session, regardless of the scope of the T-SQL statement that generated the value.
SQL Server Create SCHEMA
A Schema in SQL Server is a collection of database objects associated with a database.
SQL Server Recursive CTE
A Recursive CTE (Common Table Expression) is a CTE that references itself. In doing so, the initial CTE is repeatedly executed, returning subsets of data, until it returns the complete result set.
SQL Server CONCAT_WS Function
SQL Server CONCAT_WS() function is a string function that is used concatenates two or more strings together with a separator.
It separates those concatenated string values with the delimiter specified in the first function parameter.
SQL STRING_SPLIT function
SQL Server STRING_SPLIT function is used to split a string into a table that consists of rows of substrings based on a specified separator. This function was introduced in SQL Server 2016 .
STRING_SPLIT requires the compatibility level to be at least 130. When the level is less than 130, SQL Server is unable to find the STRING_SPLIT function.
SQL Server ISNUMERIC Function
SQL Server ISNUMERIC( ) function is System Functions which is used to check if the expression is valid numeric type or not.
SQL Server Computed Columns
A computed column is a virtual column which is used to add a new column to a table with the value derived from the values of other columns in the same table.
Computed column is not physically stored in the table, unless column is marked PERSISTED and it is persisted only if its expression is deterministic.
SQL Server CHECK Constraint
SQL Server Check Constraints restrict the values that are accepted by one or more columns.
How to create a custom shortcuts in SQL Server
How to create a custom shortcuts for stored procedures in SQL Server ?
Identify blocked processes or long nunning query in SQL Server
Blocking occurs when a process hold a lock and other process has to wait till the first process completes.
SSRS shared data source
A shared data source is a set of data source connection properties that can be referenced by multiple reports, models, and data-driven subscriptions that run on a Reporting Services report server .
SSRS Shared DataSets
SSRS Shared Dataset is a dataset which is created by using Shared Data Source and deployed to Report Server. Shared Dataset can be used by multiple reports.
SSRS Tabular or Detail Report
SSRS Detail Report or Tabular Report .
To Creating a SSRS Detail Report , First we have to create new project and create a data source and data set . We can also take an existing project solution .
If you are new to SSRS report then , first read the following posts
SQL Server CUBE
CUBE operator is used to calculate subtotals and grand total for all combinations of grouping columns specified in the GROUP BY clause.
SQL Server GROUPING SETS
SQL GROUPING SETS allows computing multiple GROUP BY clauses in a single statement. The results of GROUPING SETS are the equivalent of UNION ALL of the specified groups.
SQL Server CHOOSE Function
SQL Server Tutorials By Pradeep Raturi : SQL Server CHOOSE Functions is the logical function that returns the item at the specified index from a list of values in SQL Server.
SQL Server IIF Function
SQL Server Tutorials By Pradeep Raturi : SQL Server IIF function is the logical function that returns one of two parts, depending on the evaluation of an expression.
Temporary table / temp table in SQL Server
Temporary or Temp tables are tables that exist temporarily on the SQL Server.