SQL Server

How to delete duplicate record from SQL Server table?

In this article I am going to explain about how to delete duplicate record from sql server table. I am using temp table concept to remove duplicate same data from sql server table.

How to create table in SQL

SQL stands for Structured Query Language. It is an ANSI standard language to communicate for relational database management system. SQL is used to store, manipulate and maintain the data in SQL server database.

Tips for SQL Server Performance

We should give high periority for SQL Server performance.

APPLY Operator in Sql Server

In this article I explain about what APPLY Operator is and where to use in SQL Server. APPLY operator allows you to join a table with table valued function. The APPLY operator is used in the FROM clause between a left table source and a right table source. CROSS APPLY and OUTER APPLY are the two forms of APPLY operator.

Step by step perform Sql Queries – Part I

Through-out the article we will learn step-by-step: How to perform Perform Sql Queries. We will discuss crud operations with usage of Sql server Queries. I have mention Queries for Some Realtime Basic Queries. This article is Part-I of a series of 'Step by step Perform Sql Queries'

Deleting duplicate rows

There are times when we have some how duplicate data in a table where each row is same and you want to delete duplicate rows form the table. This article outlines one way in which you can accomplish this task using ROW_NUMBER().

Back Up of SSRS Reports

By using the "SQL Server Reporting Services RS.EXE", we can take the Back Up of SSRS Report folder and move the reports from one server to another server. The SQL Server Reporting Services RS.EXE utility is a command line utility that can perform many scripted operation related to SQL Server Reporting Services (SSRS).

Back Up Database Task

By using the Backup Database task, a package can back up a single database or multiple databases. If the task backs up only a single database, you can choose the backup component: the database, or its files and file groups.

Using subquery as table in the FROM clause

There are times when you need to use a subquery in a FROM clause. This article outlines the correct way of using a subquery in the form clause so that you do not get an common syntax error while doing so.

Index design guide for SQL server

This article outlines the best practices to follow when creating Indexes for a database. such as using Narrow data types columns, using column with high selectivity, careful consideration for column order in index.

SQL Server Performance Killer

This article outlines the major problem areas that badly affects SQL Server performance. If you already know this problem areas then you can design database and queries with better understanding. Few of them are poor indexing, inaccurate statistics, poor query design.

Inserting explicit values into IDENTITY column

This article outlines how to insert explicit values into IDENTITY column. IDENTITY_INSERT setting is used for this purpose. This article outlines how to set IDENTITY_INSERT setting for a table ON an OFF.

Obtaining last inserted IDENTITY in table

This article outlines how to obtain last inserted IDENTITY value in a table by any session. IDENT_CURRENT function is used for this. This articles describes how to use this function and what are the limitations of this function.

Obtaining the last generated IDENTITY value

This article describes the ways available in the SQL Server to obtain the last generated IDENTITY value. Two of these are @@IDENTITY and SCOPE_IDENTITY functions. This article also describes the difference between these two functions.

COALESCE function in SQL Server

This article introduces COALESCE function. It is available in SQL server 2008 and above. It can be used to simplify a CASE expression. This function accepts a number of arguments. It evaluates the arguments in order they appear until a argument evaluates to non-null value. This non-null value is then returned by function. If all of the arguments evaluates to null, then null value is returned. Arguments can be expression of any type.

Filtered index in SQL Server

Filtered Index were first introduced with SQL Server 2008. This article outlines what is the Filtered index, how it is different from other indexes, when to use the filtered index and how to construct a filtered index.

Creating Database Diagram in SSMS and Printing in PDF using CutePDF

In this article, I will walk you through series of steps to create a database diagram in SQL Server Management Studio, adjusting page setup options to fit the entire diagram in one single page and finally printing it to a PDF file using CutePDF software. In this way you will make sure you print your entire database diagram in one single page irrespective of its complexity.

SSIS - Character Map Transformation to convert data from Upper Case to Lower case and Vice-Versa.

In this article we will see how to use the Character Map transformation in SSIS. Character Map transformation is used to do some manipulation for the string type columns. Lets understand how to use character map in ssis to convert data from Upper Case to Lower case and Vice-Versa.

Slowly Changing Dimension transformation in SSIS

In this article, I create a simple ETL package that inserting and updating the records from Source database to data warehouse dimension database/tables using Slowly Changing Dimension transformation.I am going to provide you the steps and guidance needed to manage Slowly Changing Dimension with Slowly Changing Dimension Transformation in data flow task with an example.

Temporary tables and table variables in SQL Server

This article outlines and describes the available temporary storage tables in SQL server, which are Local temporary tables, Global Temporary tables and Table Variables. Each type is useful in different scenario.

Cascading Parameter in SSRS

Cascading parameter is basically a parameter that depends on another parameter so that the list of available values for a parameter are filtered based on another parameter selection. Cascading parameter provide a way of managing large amounts of report data

Views In SQL Server with examples

This article discusses one of the objects in SQL server – "Views" A view is a virtual table based on the result-set of an SQL statement.A view contains rows and columns, just like a real table. The fields in a view are fields from one or more real tables in the database.

Difference between temporary tables and table variables

This article outlines the differences between temporary tables and table variables; such as statistics and visibility. Understanding these difference will be helpful to users to write efficient query and deciding whether to use temporary table or table variable.

DELETE and UPDATE based on JOIN

This article outlines what is DELETE and UPDATE based on JOIN operations. How to use DELETE based on join operation; and similarly how to use UPDATE based on join operation. Both syntax are not SQL standard syntax.

Using Table-valued parameters in SQL Server

This article outlines what is Table-valued parameter; how to use table-valued parameter in Stored Procedure; How to pass table-valued parameter fro client application; and restriction on the table-valued parameter.