Sql Server Articles (246) - Page 9

Change Tracking aka CT in SQL server 2008 R2 

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.

CDC in SQL server 2008 R2 (Part II) 

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

10 reasons for which we should learn and use Row_Number Function of Sql Server 2005. 

In this tutorial, we will see as how to use Row_Number function with lots of practicals.

CDC in SQL server 2008 R2 (Part I) 

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.

Write Stored Procedure On Real Cloud.. 

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.

Setup Query Shortcuts in SQL Server 

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.

Way to convert a varchar type column is to xml type with preservation of already existing data in SQL Server 

Here we will see a to convert a varchar type column is to xml type with preservation of already existing data.

Extract values from XML attributes and present in comma saperated values using XQuery in 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

Extracting values from XML nodes and present in comma separated values using XQuery in 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

Ways to store special character in XMl data type in SQL Server 

This article will demonstrate the way to store special character like less than(<), greater than (>), ampersand(&) in XML data type

Use wildcards characters in SQL queries 

Use wildcards characters like %, _ in the where clause of an sql statement. Manage Error "xml parsing <line and character details> illegal name character"

Enhancements in SQL Server 2008 

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

SQL Server - Crossword - #1 

SQL Server - Crossword Puzzle - #1

How can we take all the SQL SERVER Database Backup at once 

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.

Using Order by Clause with Column_Index instead of Column Name 

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.