Query to Find Department Wise MAX Salary of Employee
comment
Add Comment
Introduction In this article, I am going to explain how to write a query to find the department-wise max salary of employees where the salar...
Split Alphabets from Alphanumeric String In SQL Server
comment
Add Comment
Introduction This article gives an explanation about how to split alphabets from the alphanumeric string in an SQL server. Here I'll al...
Split Numbers From Alphanumeric String In SQL Server
comment
Add Comment
Introduction This article gives an explanation about how to split numbers from the alphanumeric string in an SQL server. Here I'll also ...
How to Create Dynamic PIVOT Query in SQL Server
comment
Add Comment
Introduction In this article, I am going to explain how to create a dynamic pivot query in an SQL server. I'll also explain how to creat...
Concatenate value from multiple rows to a single string in SQL Server
comment
Add Comment
This article gives an explanation about an efficient way to concatenate value from multiple rows to a single string in the SQL server. The...
How to Find Values Within a Given Range in SQL server
comment
Add Comment
Introduction This article gives an explanation about how to find the particular records from the range in the SQL server as well as sh...
How to Find the Last Date of Any Month in SQL Server
comment
Add Comment
Introduction This article provides an explanation about to find the last day of any month based on the given date in the SQL server as...
Split Comma Separated String Using STRING_SPLIT in SQL Server
comment
Add Comment
Introduction This article gives an explanation about how to split comma separated string using STRING_SPLIT function and shows you how...
![[Fixed] Error 26: Error Locating Server/Instance Specified in SQL Server 2008](https://1.bp.blogspot.com/-R15OtszxkxY/XQXNTJbuApI/AAAAAAAAAhc/pHjvRu5oVF4l_diIOOxmpZKqh8L-DeHqACLcBGAs/s72-c/a-network-related-or-instance-specified-error-sql-server.png "[Fixed] Error 26: Error Locating Server/Instance Specified in SQL Server 2008")
[Fixed] Error 26: Error Locating Server/Instance Specified in SQL Server 2008
comment
1 Comment
Introduction This article gives an explanation about how to fix an error 26 a network-related or instance-specific error occurred whil...
The MERGE Statement in SQL Server
comment
Add Comment
Introduction This article gives an explanation about the MERGE statement in SQL server. Basically, the MERGE statement in SQL server j...
PIVOT and UNPIVOT in SQL Server with Example
comment
Add Comment
Introduction This article gives an explanation about the pivot and unpivots operators in SQL server with example. The process of con...
SQL Server - Create Missing Index From Actual Execution Plan
comment
Add Comment
Introduction This article gives an explanation about how to find and create a missing index from SQL server query execution plan and a...
Query to Generate Parent-Child Relation Rows By Splitting String in SQL Server and PostgreSQL
comment
Add Comment
Introduction This article gives an explanation about how to create parent-child relation by splitting the string in SQL server as well...
SQL Server - Calendar Date (Date, Day, Month, Weekday)
comment
Add Comment
Introduction This article gives an explanation about how to get calendar date in SQL server with Date, Day, Month, Weekday, Quarter, D...
SQL Server - How to Declare Variables and Set Values in Variable
comment
Add Comment
Introduction This article gives an explanation about how to declare variable and set value in SQL server and how to set value in a var...
SQL Server STUFF() Function With Syntax and Example
comment
Add Comment
Introduction This article gives an explanation about STUFF() Function in SQL Server and shows you what is STUFF() Function in SQL Se...
SQL Server Basic Performance Tuning Tips and Tricks
comment
Add Comment
Introduction This article gives an explanation of some of the basic performance tuning techniques in SQL Server and also explains how ...
Fixed - SQL Server Restore Database Error | Alter Database Mode Single User to Multi User
comment
Add Comment
Introduction This article gives an explanation about how to fix SQL server restore database error and also show you how to alter data...
Cursor in SQL Server With Syntax and Example
comment
Add Comment
Introduction This article provides an explanation about how you can use and set up a basic cursor in SQL Server. many developers/pro...
Delete/Remove Duplicate Records From Table Using CTE (Common Table Expression) In SQL server
comment
Add Comment
Introduction In this article, I am going to explain how you can delete/remove duplicate records from the table with Common Table Exp...