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.

Links

  • Tapan Patel

    How to check the database status on SQL Server

    It is rather good to be check for the database status before waiting for server to respond in case of failures.
    Tapan Patel Jul 27, 2016
  • Kalyan Penumutchu

    Exploring SQL Server Data Tools in Visual Studio 2013

    Exploring SQL Server Data Tools in Visual Studio 2013
    Kalyan Penumutchu Jun 13, 2016
  • Ranjit Powar

    SQL Server Management Studio Keyboard Shortcuts

    This link gives list of shortcuts of SQL Server Management Studio 2016 and 2008.
    Ranjit Powar Jan 01, 2016
  • Jasminder Singh

    Generate database back-up using SQL Query

    The following link explains how we can generate database back-up using a SQL command, apart from using the SQL wizard.
    Jasminder Singh Nov 16, 2015
  • Jasminder Singh
  • Sujeet Suman

    Query Execution Plan Basics

    Query Execution Plan Basics
    Sujeet Suman Oct 06, 2015
  • Dhanik Sahni

    Database optimization techniques you can actually use

    Database optimization techniques you can actually use.
    Dhanik Sahni Jun 21, 2015
  • Yashwant Vishwakarma

    Learn SQL Server Database Administration

    From this resource you can have idea about SQL Server Database administration.
  • Yashwant Vishwakarma

    SQL Server 2016 New Features

    From this link you will know all new features of SQL Server 2016.
  • Yashwant Vishwakarma

    SQL Server White Paper Gallery

    Follow below link for SQL Server White Papers.
  • Yashwant Vishwakarma

    SQL Server Video Archive

    The most popular videos from the SQL Server TechCenter are available for download in both WMV and MP4 formats.
  • Pradip Pandey

    Database Normalization Basics

    Have you reached the point of having seen the term "normalization" used database literature, but you are still unsure as to just what you have to do to get a normalized database? If so, then you’re...
    Pradip Pandey Apr 15, 2014
  • Akkiraju Ivaturi

    SSRS Properties - Columns

    This article discusses about properties available for Columns in SSRS.
    Akkiraju Ivaturi Feb 02, 2013
  • Pradip Pandey

    Cause of Poor Performance in SQL Server

    There are many causes of poor performance in SQL server when data grown and load on the server increased.
    Pradip Pandey Jan 23, 2013
  • Pradip Pandey

    Create a Sequence in SQL Server 2012

    Create a sequence in SQL Server 2012.
    Pradip Pandey Jan 22, 2013
  • Akkiraju Ivaturi

    Why Avoiding Multiple Code Blocks in a Stored Procedure

    This article discusses on the need to avoid multiple code blocks in a stored procedure.
    Akkiraju Ivaturi Jan 22, 2013
  • Akkiraju Ivaturi

    Script to Populate Date Dimension, without Using a Cursor

    This article discusses on writing script to populate date dimension without using a cursor.
    Akkiraju Ivaturi Jan 22, 2013
  • Akkiraju Ivaturi

    Database Designing With Performance in Mind

    This article discusses on designing database with keeping performance in mind.
    Akkiraju Ivaturi Jan 22, 2013
  • Akkiraju Ivaturi

    A Look Inside SQL Server Row and Page Compression

    In this article, author discusses on the value data compression has and efficiency gains that can be had by utilizing this enterprise-level feature.
    Akkiraju Ivaturi Dec 24, 2012
  • Shankar M

    IDENT_CURRENT

    IDENT_CURRENT column in SQL Server.
    Shankar M Dec 14, 2012