Sql Server Articles (246) - Page 4

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
Tips to write a better TSQL Query for enhancing the performance of Stored Procedure - Part II 
Last updated on: 03 Feb 2016 03:41:17 AM by Rajnilari2015 | Views: 2836 | Category: Sql Server |
Votes: 2 | Rating: 5 out of 5
This is a series of article that will guide us how to write a better TSql query for enhancing the performance of Stored Procedure.This is the Part II of the series.In this series we will address the problems that a WHILE LOOP (AKA Pseudo Cursor) and a CURSOR pose and also a SET BASED approach as how to overcome them with pratical example will be demonstrated.
Rajnilari2015
Tips to write a better TSQL Query for enhancing the performance of Stored Procedure - Part I 
Last updated on: 03 Feb 2016 03:36:08 AM by Rajnilari2015 | Views: 2933 | Category: Sql Server |
Votes: 2 | Rating: 4.5 out of 5
Many times it so happens that we write a query but that is not optimized and henceforth it takes a long time to get execute. This is a series of posts that will address various problems of bad way of writing a TSQL program and what is the suggested way of writing which on the other hand will boost the query performance.
Rajnilari2015
Find values from outside braces using T-SQL and XQuery 
Last updated on: 12 Jan 2016 10:25:08 PM by Rajnilari2015 | Views: 2495 | Category: Sql Server |
Votes: 2 | Rating: 4.5 out of 5
Suppose we have a text like "Hello!!!This is text1 (text1).This is text2(text2).This is text3(text3) and text4(text4)".And the objective is to figure out the value outside the brackets [ ( and ) ].In this article, we will look into one of the techniques as how can we achieve this.
Questpond
Learn MSBI Step by Step Part 1 (Installation) 
Last updated on: 02 May 2016 10:58:53 AM by Questpond | Views: 18390 | Category: Sql Server |
Votes: 2 | Rating: 5 out of 5
In this article we will learn SQL Server MSBI Step by step.
Rajnilari2015
Perform Android Like Search in TSQL 
Last updated on: 01 Jan 2016 10:30:32 PM by Rajnilari2015 | Views: 1620 | Category: Sql Server |
Sometime back, in the DNF forum a question has been asked about implementing an search like Android one. This post is an attempt to provide an answer for the same using TSQL.
Rajnilari2015
Concatenation Using For XML Path with a reference to Junction Table in SQL Server 
Last updated on: 01 Jan 2016 12:20:41 AM by Rajnilari2015 | Views: 2112 | Category: Sql Server |
Votes: 1 | Rating: 5 out of 5
In this article we will Concatenate Using For XML Path with a reference to Junction Table in SQL Server
Rajnilari2015
Generate and Publish Script Wizard of SQL Server 
Last updated on: 28 Dec 2015 02:16:25 AM by Rajnilari2015 | Views: 2278 | Category: Sql Server |
Votes: 1 | Rating: 5 out of 5
The Generate and Publish Script Wizard of SQL Server helps to generate sql scripts and later on use that in other medium(s) like import to Version Control (e.g. TFS/SVN/Accurev etc.), generate scripts in some other SQL Server Instance etc. In this step by step article we will look into how to do so.
  • Rajnilari2015
    Find values within braces using T-SQL and XQuery 
    Last updated on: 28 Nov 2015 08:23:17 PM by Rajnilari2015 | Views: 1834 | Category: Sql Server |
    Suppose we have a text like "Hello !!! We are [DNF] Dotnetfunda.Please use [F5] the site properly to get more information about [MS] Microsoft Technologies". And the objective is to figure out the value within the brackets ([ and ]). In this article, we will look into one of the techniques as how can we achieve this using T-SQL and XQuery.
    Rajnilari2015
    Difference between DENSE_RANK and ROW_NUMBER function with a case study 
    Last updated on: 16 Nov 2015 12:40:54 AM by Rajnilari2015 | Views: 2125 | Category: Sql Server |
    In many cases, developers get confuse between the difference of DENSE_RANK and ROW_NUMBER function.These both are ranking function being introduce in SQL Server 2005.In this article we will look into the difference between these two function by using a case study.
    Rajnilari2015
    Email Validation in SQL using Pattern Matching as a case study 
    Last updated on: 13 Nov 2015 05:31:55 AM by Rajnilari2015 | Views: 4094 | Category: Sql Server |
    This post is just to bring up some alternate uses of the 'LIKE' operator in SQL, probably as a possible alternative to regex - at least for a couple of scenarios. Pattern matching is an integral part of our day to day programming. For example, let us consider validating an email address by SQL.
    Rajnilari2015
    Extract numbers from string using T-SQL 
    Last updated on: 13 Nov 2015 05:35:47 AM by Rajnilari2015 | Views: 3953 | Category: Sql Server |
    In many high end programming languages like C#,Java,JavaScript etc. they provide a feature call as regular expression to do this kind of operation and it is quite handy also for this kind of job. However, SQL Server is doesn't provide such an option to do so. But with a little of effort and trick we can obtain that. This article is mainly focus on how to do so.
    Rajnilari2015
    Create Custom Templates in SQL Server 2012 
    Last updated on: 29 Sep 2015 03:55:32 AM by Rajnilari2015 | Views: 2443 | Category: Sql Server |
    In this article, we will look into as how we can create Custom Templates in SQL Server 2012
    Rajnilari2015
    Let's play with Surrounded With Feature of SQL Server 2012 - Step by Step guidance 
    Last updated on: 29 Sep 2015 01:10:37 AM by Rajnilari2015 | Views: 1736 | Category: Sql Server |
    Votes: 2 | Rating: 5 out of 5
    SQL Server 2012(Denali) has brought a lot of new features .One among them is the Surrounded WithFeature.This feature will help us to implant a block of SQL statement within a Begin..End blocks,WHILE loop block or within an IF statement.In this article, we will look into as how we can get the benefit from this feature
    Rajnilari2015
    Sort using Hierarchyid of SQL Server 2008 
    Last updated on: 21 Sep 2015 06:58:26 AM by Rajnilari2015 | Views: 2738 | Category: Sql Server |
    Votes: 1 | Rating: 3 out of 5
    This article will basically focus on sorting of hierarchical data using the Hierarchyid of SQL Server 2008
    Rajnilari2015
    RollUP function in conjunction with IIF and CHOOSE function of DENALI 
    Last updated on: 19 Sep 2015 04:17:16 PM by Rajnilari2015 | Views: 1914 | Category: Sql Server |
    Votes: 2 | Rating: 5 out of 5
    In SQL Server, if we want to perform the Total and Subtotals inorder to gerenate the reports, we can take the help of the RollUP function.In this short article, we will see the usage of the same in conjunction with IIF and CHOOSE function of DENALI