Sql Server Articles (246) - Page 9

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.
 
Vishvvas
Change Tracking aka CT in SQL server 2008 R2 
Last updated on: 30 Jul 2012 04:40:21 AM by Vishvvas | Views: 11012 | Category: Sql Server |
This article explores one of the features (of SQL server 2008 and higher) of providing the change tracking abilities i.e. what data has changed.
Vishvvas
CDC in SQL server 2008 R2 (Part II) 
Last updated on: 18 Jul 2012 12:45:00 AM by Vishvvas | Views: 7603 | Category: Sql Server |
Votes: 1 | Rating: 5 out of 5
This article (Part II) discusses the intrinsic of CDC as one of the feature (of SQL server 2008 and higher) for providing the data auditing abilities
Niladri.Biswas
10 reasons for which we should learn and use Row_Number Function of Sql Server 2005. 
Last updated on: 15 Jul 2012 01:55:17 AM by Niladri.Biswas | Views: 12212 | Category: Sql Server |
Votes: 3 | Rating: 4.33 out of 5
In this tutorial, we will see as how to use Row_Number function with lots of practicals.
Vishvvas
CDC in SQL server 2008 R2 (Part I) 
Last updated on: 14 Jul 2012 06:47:04 AM by Vishvvas | Views: 22624 | Category: Sql Server |
Votes: 1 | Rating: 5 out of 5
This article (Part I) explores one of the feature (of SQL server 2008 and higher) of providing the auditing abilities i.e. CDC – Change Data Capture. We will discuss the intrinsic of CDC in Part II.
Deviprasads
Write Stored Procedure On Real Cloud.. 
Last updated on: 05 Jul 2012 02:37:57 PM by Deviprasads | Views: 4588 | Category: Sql Server |
Votes: 1 | Rating: 5 out of 5
Always we are not so fortunate to work with only SQL server through out our whole life. Sometimes we may have to come across different databases like DB2, MySQL, Sybase etc.. In this article we are going to create a dynamic sql query where we will pass few parameters into it through command line interface at the time of execution. You all must have been questioning yourself, why has not this guy adopted a simple stored procedure instead of breaking his head on scripting so much? That’s a nice question, I agree. Think, suppose you are not the DBA in your organization and have been restricted to create stored procedure in live database but on regular task you want to fetch few data for audit and delete some older history from the table with passing some different parameters for strong condition, each time.
Arunjith
Setup Query Shortcuts in SQL Server 
Last updated on: 12 Jun 2012 06:23:02 AM by Arunjith | Views: 4767 | Category: Sql Server |
Votes: 3 | Rating: 4.67 out of 5
SQL Server Management studio provides a very useful functionality called query shortcuts. This makes the task of querying the sql server easier. Just by pressing two keys on the keyboard a complex query can be executed.
Niladri.Biswas
Way to convert a varchar type column is to xml type with preservation of already existing data in SQL Server 
Last updated on: 11 Jun 2012 01:00:37 AM by Niladri.Biswas | Views: 5238 | Category: Sql Server |
Here we will see a to convert a varchar type column is to xml type with preservation of already existing data.
  • Niladri.Biswas
    Extract values from XML attributes and present in comma saperated values using XQuery in SQL Server 
    Last updated on: 10 Jun 2012 10:56:36 PM by Niladri.Biswas | Views: 18323 | Category: Sql Server |
    In this article we will figure out as how to extract values from XML Attributes and present in comma separated values using XQuery
    Niladri.Biswas
    Extracting values from XML nodes and present in comma separated values using XQuery in SQL Server 
    Last updated on: 10 Jun 2012 10:37:51 PM by Niladri.Biswas | Views: 18792 | Category: Sql Server |
    In this article we will look into some methods as how to extract values from XML nodes and present in comma separated values using XQuery
    Niladri.Biswas
    Ways to store special character in XMl data type in SQL Server 
    Last updated on: 10 Jun 2012 04:31:04 AM by Niladri.Biswas | Views: 51464 | Category: Sql Server |
    Votes: 1 | Rating: 4 out of 5
    This article will demonstrate the way to store special character like less than(<), greater than (>), ampersand(&) in XML data type
    Samrat153
    Use wildcards characters in SQL queries 
    Last updated on: 14 Mar 2012 01:43:20 PM by Samrat153 | Views: 9253 | Category: Sql Server |
    Use wildcards characters like %, _ in the where clause of an sql statement. Manage Error "xml parsing <line and character details> illegal name character"
    Phaneendhra
    Enhancements in SQL Server 2008 
    Last updated on: 09 Jan 2012 01:15:09 AM by Phaneendhra | Views: 7329 | Category: Sql Server |
    Votes: 2 | Rating: 4 out of 5
    With SqlServer 2008 version various new Transact-SQL programmability features and Enhancements of some existing features has been introduced by Microsoft. This article covers some new features/ Enhancements in Sql server 2008
    PandianS
    SQL Server - Crossword - #1 
    Last updated on: 08 Sep 2011 08:38:59 AM by PandianS | Views: 8325 | Category: Sql Server |
    Votes: 1 | Rating: 4 out of 5
    SQL Server - Crossword Puzzle - #1
    Rn2786
    How can we take all the SQL SERVER Database Backup at once 
    Last updated on: 20 Jul 2011 05:42:50 PM by Rn2786 | Views: 8466 | Category: Sql Server |
    Here I am going to share how can we take the database backup of all the SQL Server databases at once instead of taking it individually.
    RaviRanjanKr
    Using Order by Clause with Column_Index instead of Column Name 
    Last updated on: 18 Jul 2011 05:54:44 PM by RaviRanjanKr | Views: 9378 | Category: Sql Server |
    Votes: 2 | Rating: 5 out of 5
    This article enable you to learn how to use Column Index Number instead of Column Name in the order by clause and where it should be used.