Sql Server Articles (246) - Page 7

Articles posted by registered members of DotNetFunda.com. You can also post an article and win monthly prizes as well as gain community credit points.

246 records found.
 
Adamgorge
A Closer Look at the Restore and Recovery Process in SQL Server 
Last updated on: 21 Mar 2013 12:07:25 AM by Adamgorge | Views: 5487 | Category: 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.
Lakhwinder.Ghuman
XML and XQuery in SQL Server 
Last updated on: 03 Jan 2013 03:46:58 AM by Lakhwinder.Ghuman | Views: 4848 | Category: 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.
Saratvaddilli
Global Variables in SQL Server - Part3 
Last updated on: 08 Dec 2012 03:56:06 AM by Saratvaddilli | Views: 5226 | Category: Sql Server |
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
Deviprasads
A handy SPROC for all DBA and developers 
Last updated on: 02 Dec 2012 02:11:35 PM by Deviprasads | Views: 3805 | Category: Sql Server |
Votes: 1 | Rating: 5 out of 5
In an aim to save time and key strokes while writing codes.
Niladri.Biswas
Let us spend some time with sys.dm_fts_parser 
Last updated on: 26 Nov 2012 10:37:27 PM by Niladri.Biswas | Views: 9057 | Category: Sql Server |
In this article we will learn about sys.dm_fts_parser dynamic management function
Deviprasads
The culprit behind a TRANSACTION statement in SQL 
Last updated on: 25 Nov 2012 05:32:06 PM by Deviprasads | Views: 6825 | Category: Sql Server |
Votes: 3 | Rating: 3.33 out of 5
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.
Rajarajah
How to set Primary Key and Foreign Key in SQL Server 2008 
Last updated on: 18 Nov 2012 11:35:20 PM by Rajarajah | Views: 5178 | Category: Sql Server |
This article will be useful for beginners of T-SQL to create Primary Key and Foreign Key in SQL Server 2008.
  • Niladri.Biswas
    Let's learn Last_Value Function in Sql Server 2012 
    Last updated on: 12 Nov 2012 10:28:03 PM by Niladri.Biswas | Views: 3987 | Category: Sql Server |
    In this article we will learn Last_Value function of Sql Server 2012 (Denali).
    Niladri.Biswas
    Let's learn First_Value Function in Sql Server 2012 
    Last updated on: 12 Nov 2012 10:21:01 PM by Niladri.Biswas | Views: 3220 | Category: Sql Server |
    In this article we will learn First_Value function of Sql Server 2012 (Denali).
    Niladri.Biswas
    Let's learn Lag Function in Sql Server 2012 
    Last updated on: 09 Nov 2012 01:29:28 AM by Niladri.Biswas | Views: 3357 | Category: Sql Server |
    In this article we will learn Lag function of Sql Server 2012 (Denali).
    Niladri.Biswas
    Let's learn Lead Function in Sql Server 2012 
    Last updated on: 08 Nov 2012 11:41:00 PM by Niladri.Biswas | Views: 3598 | Category: Sql Server |
    In this article we will learn Lead function of Sql Server 2012 (Denali).
    Saratvaddilli
    Global Variables in SQL Server - Part2 
    Last updated on: 05 Nov 2012 03:55:06 AM by Saratvaddilli | Views: 6488 | Category: Sql Server |
    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
    Saratvaddilli
    Global variables in Sql Server - Part1 
    Last updated on: 05 Nov 2012 03:50:37 AM by Saratvaddilli | Views: 19387 | Category: Sql Server |
    Votes: 1 | Rating: 5 out of 5
    In this article we are going to learn the global variables in sql server 2008
    rajasekharbollareddytcs-18592
    System Databases Restoration 
    Last updated on: 11 Oct 2012 05:20:41 AM by rajasekharbollareddytcs-18592 | Views: 3207 | Category: Sql Server |
    Votes: 1 | Rating: 5 out of 5
    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.
    Sagarvt
    SSRS 2008 a developer note book 
    Last updated on: 10 Oct 2012 06:24:50 AM by Sagarvt | Views: 5552 | Category: Sql Server |
    Votes: 1 | Rating: 4 out of 5
    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.