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.

RECENT POSTS

  • Vishal Pawar

    Pros And Cons Of Money DataType

    Pros And Cons Of Money DataType.
    Vishal Pawar Jun 02, 2017
  • Vishal Pawar

    ALL In One DataBase Hero Script - Set One

    ALL In One DataBase Hero Script.
    Vishal Pawar Jun 01, 2017
  • Vishal Pawar

    Time And Date Query Code And Analysis - Part One

    Time and Date query code and analysis.
    Vishal Pawar May 31, 2017
  • Priyaranjan K S

    Transparent Data Encryption In SQL Server

    Transparent Data Encryption in SQL Server.
    Priyaranjan K S May 31, 2017
  • Vishal Pawar

    Analyzing The Size Of Database And Size Of Table

    Analyzing The Size Of Database And Size Of Table.
    Vishal Pawar May 31, 2017
  • Vishal Pawar

    Identifying Relationship Between Columns In SQL

    Identifying relationship between columns in SQL.
    Vishal Pawar May 30, 2017
  • Saravanan V

    Optimizing Stored Procedures In SQL Server

    This post provides some guidance on improving the slow performance stored procedures.
    Saravanan V May 30, 2017
  • Vishal Pawar

    How To Create A Solution And What Its Uses Are

    How to create a Solution and what its uses are.
    Vishal Pawar May 25, 2017
  • Vishal Pawar

    All About Primary Key And Its Basics

    All About Primary Key And Its Basics
    Vishal Pawar May 24, 2017
  • Nemi Chand

    Move SQL Server Database To Another Location - Lesson Learned

    Fix: Unable to open the physical file. Operating system error (Access is denied.). In this article, we'll learn the best practice of moving database to another physical location on the Server.
    Nemi Chand May 22, 2017
  • Deepak

    High Availability And Disaster Recovery In SQL Server - A Quick Note

    High Availability And Disaster Recovery - A Quick Note.
    Deepak May 20, 2017
  • Dipendra Singh Shekhawat

    Temporary Tables And Table Variables In SQL

    In this article, I will explain the difference between temporary tables and table variables in SQL server.
  • Pravat Kumar

    ColumnStore Index In SQL Server

    This blog exhibits Columnstore Index in SQL Server.
    Pravat Kumar May 16, 2017
  • Asad Ali

    Getting Ado Connection From Nhibernate

    This blog show you how to use the nhibernate connection and transaction instead of opening a new ado connection.
    Asad Ali May 16, 2017
  • Deepak

    Resolving Connection Errors In SQL Server Multi-Subnet Availability Group

    In this blog, I am trying to explain how I solved "connection timeout" errors while executing SQL Jobs, which are part of primary node in "AlwaysOn" multi subnet AG setup
    Deepak May 16, 2017
  • Sourabh Somani

    How To Find All Months Of a Particular Quarter In SQL Server

    In this blog, you will learn how you can find all the months of a particular quarter.
    Sourabh Somani May 16, 2017
  • Zahid Mustafa

    Connect To SQL Server Error 40, 2

    Sometimes this happens when you start Windows and Open Microsoft SQL Server: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not ...
    Zahid Mustafa May 16, 2017
  • Madhan Raghu

    Extract JSON Data Using Custom DLL In SSRS

    This article enables you to extract JSON data, using custom DLL in SSRS.
    Madhan Raghu May 15, 2017
  • Pravat Kumar

    Some Simple Queries That Might Be Helpful

    Some simple queries that might be helpful
    Pravat Kumar May 13, 2017
  • Dipendra Singh Shekhawat

    Ten SQL Server Shortcuts You Must Know

    Ten SQL Server Shortcuts You Must Know.
  • Satyaprakash Samantaray

    User-Defined Table Type and Table Valued Parameters In Stored Procedure To Reduce The Code Size I...

    Table Valued Parameter allows a table (i.e multiple rows of data) to be passed as a parameter to a stored procedure.
  • Yashwant Vishwakarma

    Installing SQL Server vNext On Linux - Part One

    Installing SQL Server vNext On Linux.
  • Satyaprakash Samantaray

    Find List Of Tables Used In Stored Procedure Using Types Of Joins

    This blog enables you to find the list of tables used in the stored procedure, using types of joins.
  • Sateesh Arveti

    Resolving "Cannot Connect To .\sqlexpress Using SQL Server Authentication"

    In this blog, we will understand how to resolve "cannot connect to a local\remote SQL Server instance using SQL Server authentication with a error code: 18456".
    Sateesh Arveti May 08, 2017
  • Satyaprakash Samantaray

    Apply Div Tag In Stored Procedure Using SQL Server To Add Body , Header , Footer Text Details In ...

    In this blog, I have added div tag in the stored procedure, as I used in ASP.NET html.