Sql Server Articles (246) - Page 3

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.
 
Rajnilari2015
Use of OVER CLAUSE with Aggregate function to make Analytic Function in Sql Server 
Last updated on: 29 Oct 2016 10:46:17 PM by Rajnilari2015 | Views: 1536 | Category: Sql Server |
In this article, we will look into an example of the use of OVER CLAUSE with Aggregate function to make Analytic Function in Sql Server.
Rajnilari2015
Use of IIF for sorting records in SQL Server 
Last updated on: 29 Oct 2016 09:30:34 PM by Rajnilari2015 | Views: 1878 | Category: Sql Server |
In this article, we will look into how to sort records using the IIF function.
Rajnilari2015
Alpha-Numeric Sorting in SQL Server 
Last updated on: 18 Oct 2016 11:11:14 PM by Rajnilari2015 | Views: 1315 | Category: Sql Server |
In this article will discuss an approach for alpha-numeric sorting of records
Rajnilari2015
Sort records based on Numeric Ranking in SQL Server 
Last updated on: 13 Oct 2016 02:11:08 AM by Rajnilari2015 | Views: 889 | Category: Sql Server |
This article will discuss some approach in order to sort the records based on their numeric ranking.
Rajnilari2015
Update record based on the latest time & Row_Number in SQL Server 
Last updated on: 11 Oct 2016 12:45:28 AM by Rajnilari2015 | Views: 1917 | Category: Sql Server |
The objective is to demonstrate the capability of generating sequential number using Row_Number() function inside a group and to perform Update operation.
Rajnilari2015
Rows to Column Transformation in SQL Server 
Last updated on: 09 Oct 2016 11:56:31 PM by Rajnilari2015 | Views: 1377 | Category: Sql Server |
Votes: 1 | Rating: 5 out of 5
The objective of this article is to demonstrate the various ways of transforming Rows to Column in SQL Server
Rajnilari2015
TSQL Script to find the Largest Prime Number 
Last updated on: 03 Oct 2016 03:01:45 PM by Rajnilari2015 | Views: 1485 | Category: Sql Server |
In this article, we will look into how to find the largest Prime Number given a set of numbers using TSQL
  • Dharm
    Transaction in SQL Server 
    Last updated on: 19 Sep 2016 06:45:45 AM by Dharm | Views: 1559 | Category: Sql Server |
    Votes: 2 | Rating: 4 out of 5
    In this article we will explain transaction in SQL Server.
    Rajnilari2015
    Invoke A Stored Procedure from MultiStatement Table Valued Function - Step by Step 
    Last updated on: 08 Aug 2016 12:37:17 AM by Rajnilari2015 | Views: 1670 | Category: Sql Server |
    A Multi-Statement Table-Valued user-defined function returns a table. We know that a Stored Procedure return a result set which can be hold in a table. In this article we will look into how we can achieve the same. We will perform the experiment in SQL Server 2014's tempdb.
    Rajnilari2015
    How to use Dynamic Data Masking of SQL Server 2016 
    Last updated on: 09 Jun 2016 02:22:03 AM by Rajnilari2015 | Views: 2209 | Category: Sql Server |
    SQL Server 2016 was released on June 1st, 2016.Like the other versions of it's clan, this time also SQL Server has come up with lot's of new features. In this article we will explore the Dynamic Data Masking feature.
    Rajnilari2015
    How to use STRING_SPLIT function of SQL Server 2016 
    Last updated on: 08 Jun 2016 11:50:22 PM by Rajnilari2015 | Views: 2432 | Category: Sql Server |
    SQL Server 2016 was released on June 1st, 2016.Like the other versions of it's clan, this time also SQL Server has come up with lot's of new features. In this article we will explore the STRING_SPLIT function.
    Rajnilari2015
    Advice for becoming SQL Server DBA for newbies - Bulleted Points 
    Last updated on: 01 Apr 2016 03:03:01 AM by Rajnilari2015 | Views: 2268 | Category: Sql Server |
    Votes: 1 | Rating: 5 out of 5
    SQL Server DBA is a kind of dream for many SQL Server professionals.However, for the aspiring newbies, it's quite confusing as which topics to focus on more and what to learn since it's again another vast ocean of knowledge. In this article, we will provide some of the bulleted points in no particular order for the same with relevant references that will act as a detail reference point.
    Rajnilari2015
    The Art of Stored Procedure Optimization - Last but not the least 
    Last updated on: 16 Mar 2016 11:20:37 PM by Rajnilari2015 | Views: 2631 | Category: Sql Server |
    Votes: 2 | Rating: 5 out of 5
    Stored Procedure optimization is an art mixed with some techniques and needs lots of patience with an eye for detail at every aspect.In this series of articles, we will provide some of the measurements that will ensure for a better performant Store Procedure.
    Rajnilari2015
    The Art of Stored Procedure Optimization - Part 1 
    Last updated on: 16 Mar 2016 10:16:54 PM by Rajnilari2015 | Views: 2746 | Category: Sql Server |
    Votes: 2 | Rating: 4.5 out of 5
    Stored Procedure optimization is an art mixed with some techniques and needs lots of patience with an eye for detail at every aspect.In this series of articles, we will provide some of the measurements that will ensure for a better performant Store Procedure.
    Rajnilari2015
    Usage of PatIndex in SQL Server 
    Last updated on: 14 Mar 2016 12:48:08 AM by Rajnilari2015 | Views: 2937 | Category: Sql Server |
    Votes: 1 | Rating: 4 out of 5
    Patindex is a SQL Server function which returns the first occurance of the location of a pattern in a string. The pattern search is not case sensitive. It is very useful in many situations. In this article, we will look into some of the usages of this function.