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.

Blogs

  • Satya Karki

    Report Server Configuration Manager Setup For SQL Server Reporting Services (SSRS)

    In this article, you will learn how to configure the setup for SQL Server Reporting Services.
    Satya Karki Jun 15, 2020
  • Sagar Jaybhay

    Learn To Use Union, Intersect, And Except Clauses

    n this article, we will understand Union, Intersect, and Except clause in SQL Server. Also, we will see the difference between Intersect and Union in SQL Server. Also, the difference between Join w...
    Sagar Jaybhay May 07, 2020
  • Dave Bland

    Optimize For Ad Hoc Workloads, What Is It?

    This post will give a high-level overview of this setting.
    Dave Bland May 04, 2020
  • Raj Kumar

    Could Not Find Server 'Server Name' In sys.servers In SQL Server

    In this blog, you will learn how to resolve the error “Could not find server 'server name' in sys.servers” in SQL Server.
    Raj Kumar Apr 24, 2020
  • Dave Bland

    TSQL Formatting - My Thoughts

    This is a blog on my thoughts on TSQL formatting. There are quite a few suggestions that are out there. These are just the rules I have been following for a number of years and they have worked for...
    Dave Bland Apr 15, 2020
  • Sagar Jaybhay

    Subqueries And Correlated Subqueries

    In this article Sagar Jaybhay explains how to write Subqueries and Correlated Subqueries in SQL Server and what to choose for performance -- Subquery or Join?
    Sagar Jaybhay Apr 13, 2020
  • Dave Bland

    Max Degree Of Parallelism Vs Cost Threshold For Parallelism

    This post will cover the differences between Max Degree of Parallelism and Cost Threshold for Parallelism. These are two server settings that have a less the ideal default value. All DBAs should ...
    Dave Bland Mar 09, 2020
  • Dave Bland

    DEADLOCK_PRIORITY: How is it Used?

    This post will go over how you can use the DEADLOCK_PRIORITY to prioritize your processes so that the most important ones aren't chosen as victims of a deadlock.
    Dave Bland Mar 05, 2020
  • Archit Shrivastava

    Apply a Single Script for Multiple Databases Using Database Name

    In this blog, I will explain to you how to apply a script or a query to multiple databases in a single execution using a database name.
    Archit Shrivastava Mar 04, 2020
  • Dave Bland

    Find Failed Logins Using Extended Events

    This post will go very a few of the methods that can be used to capture failed logins to your SQL Servers.
    Dave Bland Mar 02, 2020
  • Dave Bland

    Dave Bland's SQL Server Blog

    This post will focus on how to find what logins are mapped to database user accounts in a SQL Server database.
    Dave Bland Feb 18, 2020
  • Sagar Jaybhay

    The SQL Select Statement

    This blog explains the Select statement in SQL.
    Sagar Jaybhay Jan 28, 2020
  • Salman Beg

    Collate Clause in SQL Server

    In this blog, I will discuss the collate clause and also discuss how the expression type 'int' is invalid for collate clause error in the SQL server.
    Salman Beg Dec 17, 2019
  • Mageshwaran R

    Transaction Explained in SQL Server

    In this blog, I will explain the SQL Transaction.
    Mageshwaran R Dec 14, 2019
  • Destin Joy

    How Stellar Repair for MS SQL Fixed Corruption in MS SQL Server Database

    There are many issues when we work with SQL server. This blog will introduce a tool which we can use to repair corrupted SQL Server DBS
    Destin Joy Dec 14, 2019
  • Govardhan P

    Creating a custom sequence in MS-SQL Server.

    This blog post is for advanced T-SQL developers interested in implementing custom sequences. Customizing the sequence gives more flexibility while implementing a solution.
    Govardhan P Dec 01, 2019
  • Kumaran K

    Delete All Duplicate Rows or Records from a Table in SQL Server

    In this blog, you will learn how to delete all duplicate rows or records from a table in SQL Server
    Kumaran K Nov 30, 2019
  • Kumaran K

    Static and Dynamic Pivot Query in SQL Server

    This post explains static and dynamic pivot query in SQL Server
    Kumaran K Nov 30, 2019
  • Mageshwaran R

    Cursor Explained in SQL Server

    In this blog, I will explain the SQL Cursor.
    Mageshwaran R Nov 27, 2019
  • Govardhan P

    Altering the table Structure using the DDL command ALTER in SQL - Part 1

    The commands in this blog will help you to understand the way a table structure can be changed or altered. In this blog, one can find examples related to adding new columns, removing unwanted colum...
    Govardhan P Nov 25, 2019
  • View More