C# Corner

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...

Today, we will learn how to add Primary Key, Unique Keys, or Foreign Keys on a table after the table is created. We will be using a simple query.

In this article, we will learn how to create and use user-defined functions in SQL server. The function we write for reusability purpose to avoid complexity and duplication of code. User-defined fu...

Backup and Restore are common functions of a database administrator. In this tutorial, you learn how to create a SQL Server database backup and restore it back using SQL Server tools.

In this article, I am going to explain about best practices and programming guidelines in SQL Server, for all SQL programmers.

In this article you will learn about the most asked SQL Server Interview questions.

I am writing this article to share knowledge about Windows Functions or Windows Ranking Function(It is a sub part of the Windows Functions). There are many windows functions introduced in SQL Serve...

We all have the need to collect system and performance information regarding our SQL Servers. Some of us use third-party tools, SQL Trace, or a homegrown solution. Did you know Microsoft has a buil...

I saw this again recently and see it too often in environments so wanted to take a second to remind everyone to cycle their error logs on a regular basis. SQL Server keeps error logs and when you r...

A common table expression i.e CTE which is used to the specific temporary result set by using SELECT, INSERT, UPDATE, or DELETE statement. So the user can do further operations on it. When the user...

In this article we learned about exception handling in SQL Server, This article is the last article of T/SQL Series. Now, We will start learning MongoDB. I have to prepare some article on MongoDB ...

Hello Learners. Hope you all are doing great. I am writing this article to get the understanding about the parameter sniffing. What it is all about and how it is related to performance sometimes.

Installing SQL Server vNext On Linux. install SQL Server vNext on Ubuntu, install SQL Server on Linux. install SQL Server vNext on Linux. install SQL Server vNext.

Identifying relationship between columns in SQL. The query is given below to find the relation between any two columns in the given database. How to search the column in the database by its name.

Quite often, I see database administrators set SQL Server Max Server Memory thinking that only everything related to SQL Server uses this shared memory pool. This is a mistake. There are many thing...

In this article, we will learn about Database Triggers in SQL Server. We also learned the concept of Magic Tables in SQL Server.

In this Article we Learn about store procedures and User Defined Function in SQL Server with Example.In previous article,we discussed about T/SQL and Cursor.

In this article, I have shared some knowledge on WHERE CLAUSE and Update SQL Statement.

If you are using SQL DB in Azure and don’t have your critical database geo-replicated, you are opening yourself up to potential issues in the event of a disaster. By configuring geo-replication you...

In this article, I have created a sample XML format. Using nodes() method to shred XML into multiple rows, which propagates parts of XML documents into row sets.