| Articles |
Using the TFS as a source control repository for SSMS projects.This article explores the feature (of SQL server tools) of adding the projects into source control repository like TFS.Views: 3393 | Posted by: Vishvvas | |
How to Avoid exceptions in SQL script and making DB robustHi, In my earlier post I gave some tips to improve sql performace and some tips to improve database quality.
This post is a next step in which I gave some excellent tips which will help you to avoid or atleast minimize the database surprises which we called as 'Exceptions'.Views: 2300 | Posted by: Nakul.Lande | Votes: 1 | Rating: 5 out of 5 |
Tricks to speed up your SQL queryWe all knows that the SQL provides the basic functionality, in terms of what can be searched for or filtered by.
But some more advanced functions may be obtained, if the user knows a few tricks. Here are given few very basic tricks which can help to speed up the executions of your SQL scriptsViews: 5475 | Posted by: Nakul.Lande | Votes: 1 | Rating: 5 out of 5 |
|
|
Change Tracking (CT) vs. Change Data Capture (CDC) in SQL server 2008This article explores differences in the features (of SQL server 2008 and higher) of providing tracking and auditing abilities i.e. the change tracking (CT) and data capture (CDC) abilities.Views: 2104 | Posted by: Vishvvas | Votes: 1 | Rating: 5 out of 5 |
Change Tracking aka CT in SQL server 2008 R2This article explores one of the features (of SQL server 2008 and higher) of providing the change tracking abilities i.e. what data has changed.Views: 2978 | Posted by: Vishvvas | |
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 abilitiesViews: 1862 | Posted by: Vishvvas | Votes: 1 | Rating: 5 out of 5 |
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.Views: 3893 | Posted by: Niladri.Biswas | Votes: 3 | Rating: 4.33 out of 5 |
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.Views: 2502 | Posted by: Vishvvas | Votes: 1 | Rating: 5 out of 5 |
|
|
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.Views: 1841 | Posted by: Deviprasads | Votes: 1 | Rating: 5 out of 5 |
Setup Query Shortcuts in SQL ServerSQL 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.Views: 1975 | Posted by: Arunjith | Votes: 3 | Rating: 4.67 out of 5 |
Way to convert a varchar type column is to xml type with preservation of already existing data in SQL ServerHere we will see a to convert a varchar type column is to xml type with preservation of already existing data.Views: 1382 | Posted by: Niladri.Biswas | |
Extract values from XML attributes and present in comma saperated values using XQuery in SQL ServerIn this article we will figure out as how to extract values from XML Attributes and present in comma separated values using XQueryViews: 1581 | Posted by: Niladri.Biswas | |
Extracting values from XML nodes and present in comma separated values using XQuery in SQL ServerIn this article we will look into some methods as how to extract values from XML nodes and present in comma separated values using XQueryViews: 2351 | Posted by: Niladri.Biswas | |
Ways to store special character in XMl data type in SQL ServerThis article will demonstrate the way to store special character like less than(<), greater than (>), ampersand(&) in XML data typeViews: 3145 | Posted by: Niladri.Biswas | Votes: 1 | Rating: 4 out of 5 |
Use wildcards characters in SQL queriesUse wildcards characters like %, _ in the where clause of an sql statement.
Manage Error "xml parsing <line and character details> illegal name character"Views: 3881 | Posted by: Samrat153 | |