SQL Server

You can make money from this site by posting original and quality articles that comply with Google AdSense policies.. Also, we offer several other reward programs including monthly profit sharing, cash rewards per post, contests & prizes etc to contributing members.

Submit Your Article


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.

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...

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.

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.

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

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"

Stored Procs disappearing from SQL Server

Are you facing a strange problem that your stored procedures are disappearing from your SQL Server for no reason? Here is the solution for magically disappearing stored procs.

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

Submit Your Article