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

  • Monica Rathbun

    What Does This Little Check Box Do

    Ever wander around SQL Server properties and wonder what these little check boxes turn on? I do, and I get very tempted to check them. Here is one of those tempting little boxes that seems pretty h...
    Monica Rathbun Feb 21, 2018
  • Monica Rathbun

    VLFs - The Forgotten Foe

    How many of you check the amount of Virtual Log Files (VLFs) your transaction logs have?
    Monica Rathbun Feb 19, 2018
  • Monica Rathbun

    How To Get Started With Always Encrypted For Beginners - Part Three

    A few weeks ago, I wrote Part 1 and 2 of this series, which was a beginner’s guide to Always Encrypted. In part 3, I am going to go over what road blocks I ran into when trying to implement this so...
    Monica Rathbun Feb 15, 2018
  • Monica Rathbun

    How To Get Started With Always Encrypted For Beginners - Part Two

    In this post we will pick up where we left off in Part 1, if you haven’t read that please go back and do so. Now that we have encrypted our columns, it’s time to take a look at how we decrypt them ...
    Monica Rathbun Feb 12, 2018
  • Monica Rathbun

    How To Get Started With Always Encrypted For Beginners - Part One

    Encryption has always been intriguing to me but seemed like it could be a very complex process to set up. However, SQL Server made it very simple when they introduced Always Encrypted (AE) into SQL...
    Monica Rathbun Feb 08, 2018
  • Monica Rathbun

    Synchronous VS Asynchronous Statistics Updates

    Implement to help with performance is changing from Update Statistics Synchronous to Auto Update Statistics Asynchronously.
    Monica Rathbun Feb 07, 2018
  • Vaidehi Pandere

    Cursors In SQL Server

    A cursor is a database object which is used to retrieve data from result sets one row at a time.The cursor can be used when the data needs to be updated row by row.
    Vaidehi Pandere Feb 06, 2018
  • Monica Rathbun

    SQL Sequence Vs Identity Column

    Let’s take a look at what a Sequence is in relation to an Identity Column in SQL Server. Did you know Sequence even existed? I didn’t until I was asked about them. It’s amazing how much you can ski...
    Monica Rathbun Feb 06, 2018
  • Dennis Thomas

    Stored Procedures Vs User Defined Functions And Choosing Which One To Use

    In SQL Server, we usually come across queries, tables, views, stored procedures and functions. People often wonder what are the real differences between User Defined Functions (UDF) or simply funct...
    Dennis Thomas Dec 19, 2017
  • Suraj Krishnan

    Comparison Of Subquery And Joins

    Here, in this article, we are comparing the SQL Join and SQL Subquery.
    Suraj Krishnan Jan 15, 2018
  • Priti Kumari

    Why Dynamic Query Is Bad

    In this article, we will be talking about Dynamic Query and why it is bad.
    Priti Kumari Jan 15, 2018
  • Nirav Daraniya

    Store And Retrieve Using FILESTREAM From SQL Database

    Hello friends today I will explaining you regarding storing and retrieving image, video and other document files from SQL server using FILESTREAM future. If you are new to FIELSTREAM then read my p...
    Nirav Daraniya Jan 06, 2018
  • Nirav Daraniya

    FILESTREAM Feature In SQL Server

    Today I am explaining what FILESTREAM is and how to use FILESTREAM in SQL server.
    Nirav Daraniya Jan 04, 2018
  • Sagar Shinde

    Export SQL Result To A Text File

    This article gives an overview of how to export SQL query results to a text file.
    Sagar Shinde Dec 18, 2017
  • Nakul Chaudhari

    Remove Duplicate Rows In SQL Server Using CTE

    In this article, you will learn how to remove duplicate rows in SQL Server using CTE.
    Nakul Chaudhari Dec 11, 2017
  • Sundaram Subramanian

    Roles And Responsibilities Of SQL Developer

    In this article, I have shared the Roles and Responsibilities of a SQL Developer.
  • Bhuvanesh Mohankumar

    Audit Made Easy Without Audit Log - Part One

    In Microsoft SQL Server, the activity of each of the database table is tracked in the other table and that is called the Audit trail or Audit log of the database table.
  • Manoj Kalla

    How To Create A Stored Procedure In SQL Server Management Studio

    In this article you will learn about how to create store procedure in sql server’s SQL SERVER MANAGEMENT STUDIO and very informative information and interview questions and answers about store proc...
    Manoj Kalla Nov 25, 2017
  • Muhammad Zunair

    Introduction To SSIS

    SSIS stands for SQL Server Integration Services. It is one of the services of SQL Server and was introduced for the first time in SQL Server 2005. It’s a powerful replacement for the legacy DTS (Da...
    Muhammad Zunair Nov 24, 2017
  • Mahesh Chand

    Use SQL Server 2017 in Docker Containers

    How to use SQL Server 2017 on Docker containers to automate deployment using VSTS
    Mahesh Chand Nov 21, 2017
  • View More