SQL Server Articles

Post

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

Determine Object Dependencies in SQL Server

This article describes some of methods for determining object dependency information.
Jignesh Trivedi Mar 11, 2014
Implement IDENTITY Column in SQL Server Memory Optimized Table

This article shows how to create an INDENTITY (auto incremented) column with a memory optimized table.
Jignesh Trivedi Mar 11, 2014
Feature, Function and Keyword Not Supported by Natively Compiled Store Procedure

This article lists the many features, functions and keywords that are not available in a natively compiled Stored Procedure.
Jignesh Trivedi Mar 11, 2014
Insert Values in Identity Column in SQL Server

Learn how to insert values into an Identity column in SQL Server.
Biswa Pujarini Mohapatra Mar 08, 2014
Natively Compiled Stored Procedures in SQL Server 2014

This article describes Natively compiled stored procedures (T-SQL procedures compiled to native code and access memory optimized tables) and their use.
Jignesh Trivedi Mar 06, 2014
Delayed Transaction Durability in SQL Server 2014 (CTP2)

SQL server 2014 (CTP2) introduced Delayed Durability. It helps reduce the IO contention for writing to the transaction log.
Jignesh Trivedi Feb 27, 2014
Problems With SQL Views When Updating Records

This article explains problems with SQL Views when updating records.
Rahul Bansal Feb 26, 2014
Insert, Update and Delete in a SQL View

In this article, we will see how to insert, update and delete in a SQL View.
Rahul Bansal Feb 25, 2014
EXECUTE Statement Enhancement WITH RESULT SETS in SQL Server 2012

This article explains the EXECUTE atatement enhancement in SQL Server 2012, WITH RESULT SETS.
Jignesh Trivedi Feb 20, 2014
IDENTITY Vs SEQUENCE Object in SQL Server

This article describes the differences between an IDENTITY property and SEQUENCE object.
Jignesh Trivedi Feb 20, 2014
SEQUENCE in SQL Server 2012

This article explains the SEQUENCE value in SQL server 2012.
Jignesh Trivedi Feb 19, 2014
Delete Duplicate Rows From a Table in SQL Server

In this article you will learn how to delete duplicate rows from a table in SQL Server.
Bharath Reddy Feb 19, 2014
OFFSET and FETCH in SQL Server 2012

SQL Server 2012 has introduced two new keywords for doing pagination of the result sets: OFFSET and FETCH.
Jignesh Trivedi Feb 18, 2014
Find the 3rd or Nth Highest Salary in a Table Via Co-Related Query

This article describes how to find the 3rd or Nth highest salary in a table via Co-Related Query.
Rahul Bansal Feb 17, 2014
Lead and Lag Function in SQL Server 2012

This article explains the SQL Server 2012 two new analytical functions LEAD and LAG.
Jignesh Trivedi Feb 17, 2014
SQL Server Installation Restart Required Error

When we install SQL Server then sometimes the error Restart Required occurrs. This article explains how to solve the problem.
Abhijit Patil Feb 17, 2014
Introduction To SQL Server Management Object

SQL Server Management Objects (SMOs) were introduced by Microsoft to manage SQL Server objects in C#. This is the managed code replacement of DMOs.
Biswa Pujarini Mohapatra Feb 03, 2014
Installing SQL Server 2008

Here, you will see how to install SQL Server 2008.
Abhijit Patil Jan 27, 2014
Query to Find All About Database Schema

In this short tip you will learn how to find information about a database schema in SQL Server.
Sourabh Mishra Jan 26, 2014
How to Install SQL Server 2012 on Windows 8.1

This article explains how to easily install SQL Server 2012 in Windows 8.1.
Sanjay Kumar Jan 13, 2014

1381 - 1400 of 1687

Learn SSRS In 11 Hours

Challenge yourself

SQL Server

E-Book Download

Get Certified

MongoDB