DevSocial Articles · SQL Server articles

1561. 

      Snapshot Replication in SQL Server 2008: Part 1

      In this article, I will cover Snapshot Replication in SQL Server 2008.

      Sachin KaliaDec 16, 201424,1391,000
1562. 

      SQL Server Pre-Requisites For Installation

      This article provide the details of SQL Server 2008/2012/2014 pre-requisites for installation.

      SAShivom AgarwalDec 5, 20149,0851,000
1563. 

      Database Backup Procedure in SQL Server

      This article is about various procedures for database backup in Microsoft SQL Server.

      Priti KumariDec 3, 201411,7501,000
1564. 

      Extended Events in SQL 2012

      In this article you will learn how to work with Extended Events in SQL 2012.

      Ketak BhalsingDec 3, 201411,1491,000
1565. 

      @@ROWCOUNT Behavior With Aggregate Functions in SQL

      In this article you will learn about the @@ROWCOUNT behavior with Aggregate Functions in SQL Server.

      Abhishek GoswamiDec 3, 20149,7321,000
1566. 

      SQL Server: System Views

      In this article you will learn System Views in SQL Server.

      Vamshi KrishnaNov 26, 20149,9991,000
1567. 

      How To Send Mail Using SQL Server: Part 1

      In this article we are going to learn the concept of mail sending using the Sql Server.

      Manish Kumar ChoudharyNov 25, 201410,4331,000
1568. 

      Import Data to Another Server

      In this article you will learn how to import data or a database from another server with SQL Server Management Studio.

      Ismail Hakki SenNov 20, 20148,1721,000
1569. 

      Automated Backup Using SQL Server 2008

      This article shows how to take an automatic backup and after a week delete the prior seven days of data.

      Manish Kumar ChoudharyNov 20, 201433,6751,000
1570. 

      Temp Table vs Table Variable

      This article compares Temp Tables to Table Variables.

      GUGuest UserNov 20, 201417,6091,000
1571. 

      Split String Value Behalf on Special Character in SQL Server

      In this article you will learn how to split a string value at a special character in SQL Server.

      Joginder BangerNov 15, 201421,2571,000
1572. 

      OUTPUT Clause in SQL Server

      This article explains the OUTPUT keyword including the basic advantages of it.

      Jasminder SinghNov 15, 201459,1971,000
1573. 

      New Features Introduced in SQL Server 2014

      Microsoft has introduced some significant enhancements for SQL Server 2014, especially with In-Memory OLTP. Here are 10 new features in SQL Server 2014.

      Debasis SahaNov 14, 2014170,3851,000
1574. 

      Sorting Numbers in SQL Server Without A Sorting Function

      How to sort numbers in SQL Server. It's not a difficult task but not an easy way. In the front end are many functions that for sorting values but SQL Server has no predefined function available.

      Joginder BangerNov 14, 20146,1281,000
1575. 

      SQL Server 2012 Reports Services Configuration

      In this article you will learn how to configure the SQL 2012 Reports Services Server.

      Shiju JosephNov 6, 201411,4091,000
1576. 

      Create and Schedule a Job in SQL Server 2008

      This article explains how to create a new SQL Server job, how to schedule a job and how to set an alert for a job.

      Rahul Kumar SaxenaNov 5, 20146,5181,000
1577. 

      Configure and Send E-Mail From SQL Server

      In this article I explain how to configure and send mail from SQL Server.

      Rahul Kumar SaxenaNov 5, 201410,2941,000
1578. 

      An Introduction to SQL Server Integration Service (SSIS)

      This article provides some basics of SQL Server Integration Services.

      Shiju JosephOct 29, 201434,3621,000
1579. 

      Creating Database When MDF is Compressed

      Here you will see how to create a database when the MDF is compressed.

      Pramod ThakurOct 25, 201412,0291,000
1580. 

      How to Write a Stored Procedure in SQL Server

      In this article you will learn how to write a Stored Procedure in SQL Server.

      Pramod ThakurOct 11, 20148,5451,000
1581. 

      Joins in SQL Server

      In this article we learn about joins in SQL Server.

      Pramod ThakurOct 10, 201412,0481,000
1582. 

      Differences Among SQL Server 2000, 2005 and 2008

      This article explains the main differences among SQL Server 2000, 2005 and 2008.

      Amit TiwariSep 26, 201459,4431,000
1583. 

      Stuff Vs. Replace Vs. Substring

      In this article we learn how and why we use the stuff, replace and Substring functions in SQL Server.

      Pramod ThakurSep 22, 201462,7081,000
1584. 

      Microsoft Release Management- Database Deployment Using DACPAC

      In this article we will study how to automate a databases release to SQL Server using the Microsoft Release Management tool and Data-tier applications in Visual Studio.

      Sreekanth MohanSep 15, 201434,6301,000
1585. 

      Using Builtin Template in SQL Server

      Learn how to use SQL Server Template Explorer to find query templates and supply parameters for stored procedures, functions, tables, and other database objects.

      Akhil GargSep 12, 20146,4231,000
1586. 

      How to Get Comma Separated Values in SQL Server With Group By Facility

      This article describes how to get column values in one comma separated value in SQL Server.

      Manish Kumar ChoudharySep 10, 201441,4411,000
1587. 

      XML in SQL Server Part 2

      This article gives you an overview of working with XML in SQL Server.

      Vijaya KadiyalaSep 4, 201418,7791,000
1588. 

      XML in SQL Server Part 1

      This article gives you an overview of working with XML in SQL Server.

      Vijaya KadiyalaSep 4, 201418,9401,000
1589. 

      SQL Server 2012 System Databases

      This article explains the System databases in SQL Server 2012.

      Abhijit PatilAug 28, 201425,9441,000
1590. 

      Over Clause in SQL Server (Windows on Data) Part 2

      This article explains the over clause in SQL Server.

      Ritesh SharmaAug 28, 20148,7651,000

Everything on SQL Server, not only its articles: the SQL Server page →