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

  • Clone A SQL Server Login And Password To A New Server

    How to clone a SQL Server login and password from server A to server B.
  • Capturing Baselines on Production SQL Servers

    Capturing Baselines on Production SQL Servers.
  • SQL Server vs SQL Server v.Next

    Performance comparison between SQL Server and SQL Server v.Next
  • Changing Linked Server Passwords

    This article describe on how to change the linked server password
  • SQL Data types mapping to .NET data types

    This link refers to very basic fundamental concept where programmers have to deal with multiple data types comparison.
  • A Visual Explanation of SQL Joins

    Basic understanding about joins with examples.
  • Some useful features in SQL Server 2016

    I came across some very useful SQL Server features, which I felt like must be shared.
  • SQL Query Performance Tuning

    Here in this link is the list of queries which we use regularly and how these sql queries can be optimized for better performance.
  • 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.
  • Exploring SQL Server Data Tools in Visual Studio 2013

    Exploring SQL Server Data Tools in Visual Studio 2013
  • SQL Server Management Studio Keyboard Shortcuts

    This link gives list of shortcuts of SQL Server Management Studio 2016 and 2008.
  • 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.
  • Query Execution Plan Basics

    Query Execution Plan Basics
  • Database optimization techniques you can actually use

    Database optimization techniques you can actually use.
  • Learn SQL Server Database Administration

    From this resource you can have idea about SQL Server Database administration.
  • SQL Server 2016 New Features

    From this link you will know all new features of SQL Server 2016.
  • SQL Server White Paper Gallery

    Follow below link for SQL Server White Papers.
  • SQL Server Video Archive

    The most popular videos from the SQL Server TechCenter are available for download in both WMV and MP4 formats.
  • 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 not alone.