SQL Server

DBMS(Data Base Management System) Architecture

The DBMS architecture is divided into three levels or views: The External level/view The conceptual level/view The internal level/view Main purpose of DBMS is to provide the user with the abstract view of the data base. This means that system does not provide all the detail of the data, rather it hide the details of how data is stored and maintained

Creating and usage of View in SQL

In this article we are showing views in SQL Server 2008. A view is virtual, the data from a view is not stored physically. It is a set of queries that, when applied to one or more tables, is stored in the database as an object. A view encapsulates the name of the table. A virtual table contains column and data from multiple tables.

What is CTE? and Difference between CTE,TableVariable and Temptable..

Here we discuss about Common Table Expressions(CTE) and Difference between CTE,TableVariable and Temptable. There are so many differences between them, let me explain some of that differences with examples. Let us see...

Rar and UnRar the files in SSIS 2008 R2

In this article we are looking for how to Rar and Unrar the files like Excel,Text Files,XML or any other files by using the SSIS 2008 R2. We can compress or expand the files by using the Execute Process Task in SSIS 2008 R2.

User Defined Function in Sql-Server

Today i want to discuss an article that is regarding User Defined Functions in Sql-server.What are User Defined Functions?what are the types of User Defined Functions.In which scenario User Defined Functions are Used.This is the article i want to discuss here with Code Snippets.

Mind Trick Game using SQL Server

In this article, We play a mind trick game by using sql server! Basically we wrote a lot of procedures, functions queries etc, for our projects but this one is quite different from others! Come on let us play the game...

How to find particular highest salary from a table...

Here we discuss about to find "x" highest salary from a table.. There are so many options are available in sql server but this is best and easy way to find particular highest and lowest salary from a table...

Techniques for Recovery from transaction failures in database

Recovery from transaction failures usually means that the database is restored to the most recent consistent state just before the time of failures. To do this the system must keep the information about the changes that were applied to data items by the various transaction. This information is typically kept in the System log.

Data Driven Subscription in Sql Server Reporting Services.

Here in this resource we can learn about some basic concepts about data driven subscription option that was present in SSRS for scheduling and subscribing process. Data driven subscription is nothing but it build a query that retrives the subscription data, and it map the result set to the delivery options.

SSRS (SQL Server Reporting Services) - Create Reports using SSRS - Part 1

I would like to share my thoughts about creating a new reports using SSRS tool and designing the customised reports. Even though many of them knows about SSRS, this is the article for people who are struggling to how to start, design, connect with databases and deploy reports.

Best ways to write SQL query

Many of us never give attention how to write sql query,once we get work we simply start with writing it without consider some of the facts ,we need to consider some of rules and guidelines while writing query that will make query effective.Those are as follows..

How to Get Number of Saturday's and sunday's In SQL USING CTE

How to use CTE(Common Table Expression) in sql server and simple examples related in CTE and how to Get Number of Saturday's and Sunday's In a month USING CTE(Common Table Expression), as well as which dates Saturday's and Sunday's occurs in a month. Here we can use CTE along with OPTION(MAXRECURSION 100(COUNTS)) Keyword.

SSRS – Calling Stored Procedures and passing parameters to the same in SSRS Reports – Part 4

In this article, I would like to explain about how to use stored procedures and how to pass parameters to a specified report. This articles explains creating Stored Procedures in Management Studio and Implementing SPs in SSRS Reports and Passing Parameters to the corresponding reports for beginners who are struggle to use SP in SSRS Reports.

Can we have primary key and clustered index on same table with different field?

In this article I am going to explain what will happen if we try to create primary key on a table which is already having clustered index in it. Also this article is the answer to the question "Can we have primary key and clustered index on same table with different field?"

Stored procedure with CTE

in this article i will go to explain how to use cte in a stored procedure.i referred lot of website.but i don't get it in my training period.see the below example.i tried to use cte in storedprocedure.here i used cte in storedprocedure to split up the given number in a table.

SQL SELECT Statement Performance Tuning Tips

In this Article I am going to Explain about SQL SELECT Statement Performance Tuning Tips. Performance Tuning is important for Increase the Performance of the application. Here You will learn About SQL Server and T-SQL Performance tuning techniques. Learn SQL SELECT Statement Performance Tuning Tips

Acessing Remote Excel Files/Csv/Text Files data from Remote Server to your Local Database.

Today i am going to Introduce how to Access Remote Excel Files/Csv Files/Text Files data to Your Local sql-server table.So that with no time we can insert or bulk copy the Data to your local sql-server .So what are the steps we need to follow and how to use the query to dump or insert the data in sql-server.I will illustrate here.

Differences between stored procedures and Functions

This article will explain the differences between functions and stored procedures.

Fun and Games with SQL – Crossword Puzzle 2

Hope you are all enjoyed with my first CrossWord puzzle. Find out my Second Crossword with more interesting clues. Solve the crossword puzzle with the given clues, in which the terms are related to sql server.

Split Comma separated values into Columns

In this article, I explain about how to split a string with delimiter into list of rows. De limiter can be comma or plus our requirement is to convert a single row of a table into multiple rows based on number of delimiter.

Top with ties function in SQL

In this article, I am going to explain the use of TOP WITH TIES function and how to use it. If we want to select all the rows, with same values we have to include TOP WITH TIES option in the query statement.

Fun and Games with SQL – Crossword Puzzle 1

All of us are interested in playing games and solving puzzles, why don’t we try the same with sql server. Solve the crossword puzzle with the given clues, in which the terms are related to sql server.

DBMS(Data Base management System) users

DBMS(Data Base management System) is the software that interprets and processes users request to retrieve information from a data base. It is not only use for retrieving the information from the database but also do much more thing for its user. The user of DBMS are classified in two categories no 1. Is "Actor on the Scene" and 2. Is "Workers behind the scene"

How to make updates stick to database?

If you are working in Visual Studio and are struggling to save data to your local database then this article is for you. Visual Studio makes a copy of the database in output(debug) folder every time the project is debugged and this is the root cause of the problem. This article explains how to overcome this issue.

Introduction to PL/SQL (Procedural language / Structure Query Language)

The development of database application typically requires language constructs similar to those that can be found in programming language such as c,c++ or pascal.SQL is very flexible ,powerful and easy to learn language. Data manipulation becomes very easy with a few English like sentences. However SQL is a non-procedural language. It does not offer any programming construct for conditional selections , iteration etc. hence cannot be used as an application development tool. A solution to this problem is PL