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.
Enable Dark theme in SQL Server Management studio
How to get dark theme for SQL Server Management studio?
By default it is hidden in SQL Server management studio, you can quickly check by following below steps.
SQL Server NCHAR
NCHAR data type is used to store Unicode string data of fixed-length.
NCHAR data type is used to store Unicode string data of fixed-length.
It stores data at 2 byte per character.
It supports up to 4000 characters.
ALL Function DAX
ALL is a Power Bi DAX filter function that returns all the rows in a table or all the values in a column, ignoring any filters that might have been applied.
SQL SERVER NVARCHAR
SQL Server NVARCHAR is used to store uniqcode string data of variable length, it can store both unicode and non unicode strings.
SQL SERVER VARCHAR
SQL Server VARCHAR Data Type is used to store non-unicode string data of varaible length.
Generate calendar table in SQL Server
How to Display calendar dates for any n numbers of years in SQL Server?
SQL Server Download links
Following are the links to download SQL Server 2019 and Database sample files
How to split comma separated string values into columns
SQL Server CHAR data type is used to store non-Unicode string data of fixed-length.
SQL Server OFFSET FETCH
SQL Server OFFSET FETCH clauses are used to set the limit to number of rows returned by a query.
SQL Server PATINDEX
SQL Server PATINDEX function is a string function that returns the starting position of the first occurrence of a pattern in a specified expression.
SQL Server Verbose Truncation Warnings
SQL Server Verbose Truncation Warnings
Sometimes we receives data truncation error in SQL Server such as “String or binary data would be truncated” and it does not specify exact source of error in terms of Database name, table name , column name and truncated values.
How to find Nth Highest Salary in SQL Server
This is one of the most commonly asked question in SQL Server interview that how to find the Nth highest salary of employee with their… Read More »How to find Nth Highest Salary in SQL Server
SQL Server @@SPID
SQL Server @@SPID
SQL Server @@SPID is a SQL Server configuration function that is used to return the session id of current user process.
SYNTAX
@@SPID
SQL Server @@Version
SQL Server @@Version is a configuration function that returns system and build information for the current installation of SQL Server. SYNTAX @@Version Return Type of… Read More »SQL Server @@Version
SQL SERVER SP_MONITOR
SP_MONITOR is a SQL Server Database Engine system stored procedure which is used to Display statistics about Microsoft SQL Server.
SYNTAX
EXEC sp_monitor
SP_RENAME in SQL Server
SQL Server SP_NAME is SQL Server Database Engine stored procedure that is used to Changes the name of a user-created object in the current database. This object can be a table, index column or alias datatype.