Sql Server Articles (246) - Page 7

A Closer Look at the Restore and Recovery Process in SQL Server 

During the process of restoring SQL Server databases, data is copied from a backup and changes are then made to this data by applying logged transactions. Backups comprise transaction log records that can be used to roll forward any active transactions or roll back any uncommitted transactions to maintain transactional consistency in the database.

XML and XQuery in SQL Server 

XML Data type one of the important data types available in SQL Server, offers to declare variable and table columns to store data in the XML format, comes up with 5 main methods to use with the XQuery in SQL Server.

Global Variables in SQL Server - Part3 

Let's learn Global Variables in SQL Server.In my last articles we have already learned about Global Variables and we also learned first 20 global variables. This article is in continuation to the Global Variables in Sql Server Part-2

A handy SPROC for all DBA and developers 

In an aim to save time and key strokes while writing codes.

Let us spend some time with sys.dm_fts_parser 

In this article we will learn about sys.dm_fts_parser dynamic management function

The culprit behind a TRANSACTION statement in SQL 

Don't look at the title of this Article.. Really didn't get anything good to match up with the scenario so named something funny 'Culprit' :) We are going to look at the effects of using Transaction control in a DML statement(INSERT). I am gonna explain the topic with a real-time scenario.

How to set Primary Key and Foreign Key in SQL Server 2008 

This article will be useful for beginners of T-SQL to create Primary Key and Foreign Key in SQL Server 2008.

Let's learn Last_Value Function in Sql Server 2012 

In this article we will learn Last_Value function of Sql Server 2012 (Denali).

Let's learn First_Value Function in Sql Server 2012 

In this article we will learn First_Value function of Sql Server 2012 (Denali).

Let's learn Lag Function in Sql Server 2012 

In this article we will learn Lag function of Sql Server 2012 (Denali).

Let's learn Lead Function in Sql Server 2012 

In this article we will learn Lead function of Sql Server 2012 (Denali).

Global Variables in SQL Server - Part2 

let us learn the global variables in the sql server , in my last article we had already learned about global variables and we also learned the first 10 global variables .This article is continuation to the Global Variables in Sql Server Part-1

Global variables in Sql Server - Part1 

In this article we are going to learn the global variables in sql server 2008

System Databases Restoration 

Some times we need to restore System Databases. This may happen due to system or hard disk or any upgrade failures. We have two cases to go for restoring system databases 1)If MSSql Service is running fine then we will proceed to restoring system databases. 2)If MSSql service is not running or it is going to fail while at restarting then we need to reinstall SQLServer Software in 2005 and 2008 and in 2000 we have one option of rebuilding master database by running of the Rebuildm.exe executable and this was located at C:\Program Files\Microsoft SQL Server\80\Tools\Binn by default. In the case of one we must need to restore system databases again but in case of two it's depend on business requirement. If we restore system databases again then no need to create user logins,tables,views,triggers,procedures and Server level configurations in the System databases. I feel you might be understand why we need to restore system databases.

SSRS 2008 a developer note book 

This article describes the features like create report , deploying on report server, access report from aspx page and create a chart graph based report. Code snippets are given wherever necessary.