Sql Server Articles (246) - Page 4

Tips to write a better TSQL Query for enhancing the performance of Stored Procedure - Part II 

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.

Tips to write a better TSQL Query for enhancing the performance of Stored Procedure - Part I 

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.

Find values from outside braces using T-SQL and XQuery 

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.

Learn MSBI Step by Step Part 1 (Installation) 

In this article we will learn SQL Server MSBI Step by step.

Perform Android Like Search in TSQL 

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.

Concatenation Using For XML Path with a reference to Junction Table in SQL Server 

In this article we will Concatenate Using For XML Path with a reference to Junction Table in SQL Server

Generate and Publish Script Wizard of SQL Server 

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.

Find values within braces using T-SQL and XQuery 

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.

Difference between DENSE_RANK and ROW_NUMBER function with a case study 

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.

Email Validation in SQL using Pattern Matching as a case study 

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.

Extract numbers from string using T-SQL 

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.

Create Custom Templates in SQL Server 2012 

In this article, we will look into as how we can create Custom Templates in SQL Server 2012

Let's play with Surrounded With Feature of SQL Server 2012 - Step by Step guidance 

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

Sort using Hierarchyid of SQL Server 2008 

This article will basically focus on sorting of hierarchical data using the Hierarchyid of SQL Server 2008

RollUP function in conjunction with IIF and CHOOSE function of DENALI 

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