Sql Server Articles (246) - Page 8

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.
 
Niladri.Biswas
Let's learn IIF Function in Sql Server 2012 
Last updated on: 01 Oct 2012 04:41:39 AM by Niladri.Biswas | Views: 5376 | Category: Sql Server |
Votes: 2 | Rating: 4.5 out of 5
In this article we will learn IIF function of Sql Server 2012 (Denali).
Niladri.Biswas
Let's learn Choose Function in Sql Server 2012 
Last updated on: 01 Oct 2012 04:00:47 AM by Niladri.Biswas | Views: 3207 | Category: Sql Server |
In this article we will learn Choose Function in Sql Server 2012
Niladri.Biswas
Let's learn Format Function in Sql Server 2012 
Last updated on: 01 Oct 2012 03:43:28 AM by Niladri.Biswas | Views: 2946 | Category: Sql Server |
In this article, we shall learn Format Function of Sql Server 2012
Niladri.Biswas
Let's learn Concat Function in Sql Server 2012 
Last updated on: 01 Oct 2012 03:23:45 AM by Niladri.Biswas | Views: 2848 | Category: Sql Server |
Votes: 1 | Rating: 3 out of 5
In this article, we will learn Concat Function in Sql Server 2012
Niladri.Biswas
Let's learn Percentile_Count Function of SQL Server 2012 (Denali) 
Last updated on: 28 Sep 2012 01:55:47 AM by Niladri.Biswas | Views: 4358 | Category: Sql Server |
In this article we will learn Percentile_Count Function of SQL Server 2012 (Denali)
Niladri.Biswas
Let's learn Percentile_Disc Function of SQL Server 2012 (Denali) 
Last updated on: 28 Sep 2012 01:01:14 AM by Niladri.Biswas | Views: 3525 | Category: Sql Server |
In this article we will learn Percentile_Disc Function of SQL Server 2012 (Denali)
Niladri.Biswas
Code snippet in Sql Server 2012 (Denali) 
Last updated on: 27 Sep 2012 05:04:30 AM by Niladri.Biswas | Views: 3957 | Category: Sql Server |
Votes: 1 | Rating: 5 out of 5
In this article, we will look into the new Code Snippet feature of SQL Server 2012 (Denali).
  • Niladri.Biswas
    Let's learn Try_Parse function of SQL Server 2012 (Denali) 
    Last updated on: 20 Sep 2012 11:10:08 PM by Niladri.Biswas | Views: 4775 | Category: Sql Server |
    In this article, we will look into the Try_Parse function of SQL Server 2012 (Denali).
    Niladri.Biswas
    Let's learn Cumulative Distribution function of SQL Server 2012 (Denali) 
    Last updated on: 19 Sep 2012 02:29:56 AM by Niladri.Biswas | Views: 8374 | Category: Sql Server |
    In this article, we will look into the Cumulative Distribution function of SQL Server 2012 (Denali).
    Niladri.Biswas
    Let's learn Try_Convert function of SQL Server 2012 (Denali) 
    Last updated on: 19 Sep 2012 12:22:22 AM by Niladri.Biswas | Views: 3953 | Category: Sql Server |
    In this article, we will look into the Try_Convert function of SQL Server 2012 (Denali).
    Niladri.Biswas
    Let's learn Percent Rank function of SQL Server 2012 (Denali) 
    Last updated on: 18 Sep 2012 11:20:11 PM by Niladri.Biswas | Views: 6060 | Category: Sql Server |
    In this article, we will look into the Percent Rank function of SQL Server 2012 (Denali).
    Vishvvas
    Using the TFS as a source control repository for SSMS projects. 
    Last updated on: 03 Sep 2012 02:32:28 PM by Vishvvas | Views: 34892 | Category: Sql Server |
    This article explores the feature (of SQL server tools) of adding the projects into source control repository like TFS.
    Nakul.Lande
    How to Avoid exceptions in SQL script and making DB robust 
    Last updated on: 22 Aug 2012 10:14:07 AM by Nakul.Lande | Views: 5800 | Category: Sql Server |
    Votes: 1 | Rating: 5 out of 5
    Hi, 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'.
    Nakul.Lande
    Tricks to speed up your SQL query 
    Last updated on: 16 Aug 2012 12:24:52 PM by Nakul.Lande | Views: 24051 | Category: Sql Server |
    Votes: 1 | Rating: 5 out of 5
    We 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 scripts
    Vishvvas
    Change Tracking (CT) vs. Change Data Capture (CDC) in SQL server 2008 
    Last updated on: 30 Jul 2012 05:28:46 AM by Vishvvas | Views: 12873 | Category: Sql Server |
    Votes: 1 | Rating: 5 out of 5
    This 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.