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

  • Dinesh Singh Kushwaha (Dev)

    How To Create CLR Triggers In C# And Install And Uninstall CLR Assembly In MSSQL Server

    In this article, we will learn how to create CLR Triggers in C# and install & uninstall CLR assembly in MSSQL Server.
  • Jeeva Subburaj

    SQL Server Tips - SQL Server Paging Made Easy With OFFSET And FETCH Keyword

    This post contains SQL Server tips for applying paging in SQL that can be used in real-world applications for long-running processing with better performance
    Jeeva Subburaj May 14, 2018
  • Dinesh Singh Kushwaha (Dev)

    Create CLR Stored Procedure With And Without Namespace In C# And Install And Uninstall CLR Assemb...

    In this article, we will learn how to create a CLR Stored Procedure with & without namespace in C# and install & uninstall CLR assembly in MSSQL Server.
  • Sankara Krishnan Venugopal

    Create A Job In SQL Server

    In this session, we are going discuss how to create the SQL JOB, how to connect the Job with SSIS package and how to schedule the job on server.
  • Hemant Mahajan

    Learn About SQL Server DB Statistics

    In any application persistence of data is required. Database plays a very important role to fill this gap. Microsoft SQL server is one such database. We all know database contains multiple tables t...
    Hemant Mahajan May 08, 2018
  • Sankara Krishnan Venugopal

    Load Data From Database To Text File Using SSIS Package

    Let’s discuss how to connect the database to SSIS package and how to load the table record(s) from database to notepad file. We can pull it into notepad, excel, csv or any other extension that you ...
  • Dinesh Singh Kushwaha (Dev)

    Apply Custom Order In A Given Order Except Ascending And Descending In MSSQL Server

    In this article we will learn how to display records in custom given order except ascending & descending in MSSQL Server.
  • Monica Rathbun

    Five Ways To Examine Cardinality Metrics

    In SQL Server, the query optimizer uses a cardinality estimator to answer data SELECTIVITY questions like the ones below. The optimizer uses this cardinality data, which relies heavy on statistics ...
    Monica Rathbun May 03, 2018
  • Monica Rathbun

    Hide And Group Columns In SSRS Using A Parameter

    Ever had users come to you and request another version of a report just to add another field and group data differently? Today, was such the day for me. I really don’t like having multiple versions...
    Monica Rathbun Apr 24, 2018
  • Monica Rathbun

    SQL Server Updates Tricked Me For Years

    When applying a new SQL Server cumulative update, hot fix, or upgrade to SQL Server, it doesn’t always apply all the fixes in the patch. When you upgrade the database engine in-place, databases you...
    Monica Rathbun Apr 24, 2018
  • 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
  • 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
  • Monica Rathbun

    System-Versioned Temporal Tables

    Every once in a while, I like to take a moment and learn something new about the latest SQL Server gizmos and gadgets. Today I came across system-versioned temporal tables and it piqued my interest...
    Monica Rathbun Mar 29, 2018
  • Pragya Nagwanshi

    Monitoring Specific Table Using SQL Profiler

    This article helps you to understand how to use the SQL Profiler, and how to trace a particular table.
    Pragya Nagwanshi Mar 27, 2018
  • Monica Rathbun

    What Are These Backup Settings All About

    I ran across a client the other day that had these Backup and Recovery options set like the picture below because it defaults this way.
    Monica Rathbun Mar 23, 2018
  • Deepak Kaushik

    Let's Import Data To Azure SQL Data Warehouse Using SSIS

    We have already discussed many ways to import data in Azure DWH. Today I will discuss an OLD SCHOOL approach of data import by SQL Server Integration Services (SSIS). In my opinion, this is the mos...
    Deepak Kaushik Mar 21, 2018
  • Srashti Jain

    Pre-Deployment And Post-Deployment Script - SQL Database Project

    In this article, we will learn Pre-Deployment And Post-Deployment Script on SQL Database Project.
    Srashti Jain Mar 20, 2018
  • John Morehouse

    Learn About SSMS Output Window

    In my experience, there have been occasions where SQL Server Management Studio (SSMS) becomes unresponsive for a length of time. In one particular case, this occurred while I was expanding the list...
    John Morehouse Mar 17, 2018
  • Monica Rathbun

    Hide And Group Columns In SSRS Using A Parameter

    Ever had users come to you and request another version of a report just to add another field and group data differently? Today, was such the day for me. I really don’t like having multiple versions...
    Monica Rathbun Mar 16, 2018
  • John Morehouse

    Four Rules Of Right When Running A Query

    Earlier this year, I participated in the Idera #sqlchat. This is a monthly chat meeting that is organized by Idera Software and hosted by a SQL Server community member. This one was hosted by Moni...
    John Morehouse Mar 13, 2018
  • View More
    X

    Build smarter apps with Machine Learning, Bots, Cognitive Services - Start free.

    Start Learning Now