SQL Server Database Tutorials

SQL Server Database Management Tutorials and Database Administration Articles
  Title / Author Replies
To retrieve data from multiple tables, SQL server allows user to apply joins to the tables. Depending on the condition, user can join multiple tables or views. There are different types of join available in SQL Server as inner join, outer join, cross join, equi join, and self join. Inner Join...
The aggregate functions are used for performing operation on a set of values. The result returned is a single value. The SELECT statement is used along with the function to perform the specific operations. The syntax for the aggregate function is as shown below: SELECT aggregate_function ( )...
Using String Functions User can use the string functions for changing the string values in the result set. They can be used with char or varchar data types. They can be used as a part of the expression. The syntax for using the string function is as shown below: SELECT function_name...
There are many occasions where if someone updates a records or even deletes a record we need to keep the Audit trails of the record updated or deleted or even keep a history of records as what are the updates that happened on the database as well as what are the records deleted from the table. In...
Introduction Stored procedures are special objects available in sql server. Its a precompiled statements where all the preliminary parsing operations are performed and the statements are ready for execution. Its very fast when compared to ordinary sql statements where the sql...
A trigger is a special kind of stored procedure that is invoked whenever an attempt is made to modify the data in the table it protects. Modifications to the table are made ussing INSERT,UPDATE,OR DELETE statements.Triggers are used to enforce data integrity and business rules such as...
Introduction I had a complex SQL query that was used to extract data from my system and send it across via web request to an external system. The query was taking unduly longer time to run. I made few changes to the query structure and reduced it run time to 7 mins. A part of the main query...
Concatenating data with Multiple Result(s) using FOR XML PATH Create table #TempProducts(Items Varchar(30),Colour Varchar(15)) Insert into #TempProducts values('Table','Red'); Insert into #TempProducts values('Table','Green'); Insert into #TempProducts values('Table','Blue'); Insert...
CUBE generates a result set that represents aggregates for all combinations of values in the selected columns. CUBE automatically generates a summation rollup to the top level of a GROUP BY. Lets us look one Example. Create table #TempTable(Items varchar(30), ...
SQL Server implements Client/Server technology.A number of client send queries to the Central Server.The server after receiving the query request,parses it for syntax errors and process the request.Since the query passes from the client to the server through the network it adds to network...
Introduction This article deals with parsing techniques involved in executing the sql server query. Nowadays, stored procedures forms a strong back ground in accessing the database. Why is it so???? how it's related to my query parsing technique Background If we think about the query...
What is SMO? SQL Server Management Objects (SMO) is a collection of objects that are designed for programming all aspects of managing Microsoft SQL Server. SMO Overview SQL Server Management Objects (SMO) are objects designed for programmatic management of Microsoft SQL Server. You can...