C# Corner

Here, we will discuss the full procedure to rebuild Master Database in SQL Server without unavailability of backup. Read the complete blog very carefully to get appropriate results.

Recently, Microsoft has released the Preview 5 of SQL Server Management Studio 18.0. This is the second public preview of SSMS 18.0.

In this blog, we will learn about aggregate function in SQL Server. An aggregate function is used to calculate the given values and returns a single value.

This article explains the row_number function in SQL Server. Ranking functions provide a very good feature of assigning numbering to the records in the result set in SQL. Row_Number is one of these...

There is always a requirement from developers: How should I store images and BLOB files in SQL Server ? In this post let's explore the data types and methods used for storing Binary Large Objec...

In this article we will learn how to use pivot and unpivot relational operator in SQL Server.

In this article we learn about Date and time functions in SQL Server.These functions are working on given date and time.These functions are SQL Pre defined functions.

When I started learning SQL, I found out several issues, which I thought to be interesting to share. For our needs, let us use AdventureWorks2012 database, which can be obtained here.

In this blog, we will discuss how to work with Stored Procedure and explain the concept with an example in a simple way. I hope this is very useful for beginners and intermediate to help them under...

Here, I will tell you the possible ways to return calculated Boolean values from SQL Server code. At a lot of places, you want to progress conditionally. You send some input values to the stored pr...

Hello Learners. I hope you all are doing great. This article describes the Covering Indexes and Filtered Indexes. I would like to tell you that these type of Indexes can only be created as NONCLUST...

Did you know that compression can gain you more than just space on a disk; it can allow you to fit more data into the buffer pool? That means queries have faster and more efficient reads which can ...

This blog explains how to check, if a string contains a substring in SQL Server or not.

In this blog. I will explain you how to find random record in SQL server. This is most common interview question. The CHECKSUM function returns the checksum value computed over a table row, or over...

In this post, we will learn how to calculate the time between two dates in years, months, and days format. There is a special function for getting a perfect year, month, and day count.

In this blog, we will discuss how to work with Views in SQL Server and explain concepts with an example in a simple way. I hope this is very useful for beginners to help them understand the basic c...

This article is about merging different row cells into one for the purpose of reporting. Sometimes we need to customize according to the client’s requirements.

I hope you all are doing fine. This particular article is about updating the dynamic columns on the go.

Statistics are the magic ingredient that helps the query optimizer create its best guess for generating an execution plan. Keeping statistics as accurate as possible will give the optimizer the inf...

In this video session, we will quickly walk through the steps of creating a simple Database in SQL Server 2017 Express Edition.

In this article you will learn about how to create stored procedure in SQL SERVER MANAGEMENT STUDIO. What is Store Procedure? Why do we use SET NOCOUNT ON in stored procedure? How to write comment ...

In this article you will learn about the most asked SQL Server Interview questions. Top 50 SQL Server Interview Questions and Answers. How to delete a table in SQL Server? What is a function in SQL...

In this article, we will learn about identity function and how we Reset Identity Column in SQL Server. Identity keyword is used in SQL Server to Auto Increment Column value.

Today, in this post, I am going to explain the SQL statement which is used to to get the date and time difference in a valid format like 1 hr ago, or 30 min ago, or 1 week ago, 1 month ago, and so ...

In my series of articles there are a few scenarios where we need to take care of some real-world samples and examples to help explain concepts to the end users. This is part 49 of the series of art...