SQL Server
Welcome to SQL Server section of C# Corner. In this section, you will find various SQL Server related source code samples, articles, tutorials, and tips.

Articles

  • Karthikeyan Anbarasan

    SQL Server Integration Services (SSIS) - Real time Examples Of Data Flow Transformations In SSIS

    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...
  • Pradeep Kumar Gupta

    Add Primary Key/Unique Keys/Foreign Keys After Table Creation Using SQL Query

    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.
  • Jitendra Waghale

    An Overview Of User Defined Functions In SQL Server

    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...
    Jitendra Waghale Sep 25, 2018
  • Jitendra Waghale

    Database Backup And Restore In SQL Server

    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.
    Jitendra Waghale Sep 19, 2018
  • Bikesh Srivastava

    Best Practices And Programming Guidelines In SQL Server - Part Two

    In this article, I am going to explain about best practices and programming guidelines in SQL Server, for all SQL programmers.
    Bikesh Srivastava Nov 29, 2016
  • Nitin Pandit

    Most Asked SQL Server Interview Questions and Answers

    In this article you will learn about the most asked SQL Server Interview questions.
    Nitin Pandit Nov 10, 2015
  • Rohit Kainth

    Learn About Windows Ranking Function

    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...
    Rohit Kainth Oct 10, 2018
  • Monica Rathbun

    SQL Server Data Collection And Management Data Warehouse

    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...
    Monica Rathbun Oct 04, 2018
  • Monica Rathbun

    Overview Of Cycle Error Logs

    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...
    Monica Rathbun Sep 27, 2018
  • Rupesh Kahane

    Common Table Expressions (CTE) Example In SQL SERVER

    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...
    Rupesh Kahane Sep 28, 2018
  • Sanwar Ranwa

    T/SQL - Exception Handling - Part Five

    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 ...
    Sanwar Ranwa Sep 28, 2018
  • Rohit Kainth

    Overview Of Parameter Sniffing

    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.
    Rohit Kainth Sep 27, 2018
  • Yashwant Vishwakarma

    Installing SQL Server vNext On Linux - Part One

    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.
  • Vishal Pawar

    Identifying Relationship Between Columns In SQL

    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.
    Vishal Pawar May 30, 2017
  • Monica Rathbun

    Be Careful With Your SQL Server Max Memory Settings

    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...
    Monica Rathbun Sep 19, 2018
  • Sanwar Ranwa

    T/SQL - Database Trigger - Part Four

    In this article, we will learn about Database Triggers in SQL Server. We also learned the concept of Magic Tables in SQL Server.
    Sanwar Ranwa Sep 18, 2018
  • Sanwar Ranwa

    T/SQL - Stored Procedures and Functions - Part Three

    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.
    Sanwar Ranwa Sep 17, 2018
  • Sundaram Subramanian

    Zero To Hero In MS SQL Server - Part Six

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

    Steps For SQL DB Geo Replication

    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...
    John Morehouse Sep 15, 2018
  • Rupesh Kahane

    Bulk Insert, Update XML Data Into SQL Table

    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.
    Rupesh Kahane Sep 14, 2018
  • View More