SQL Server Database Tutorials

SQL Server Database Management Tutorials and Database Administration Articles

	Title / Author	Replies Views
	Audit Trail in SQL Server 2000 or SQL Server 7 ( 1 2) 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... By shabbir Last Message By deonrock	10 23,687
	Stored Procedure in sql server 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... By venkatesanj@hcl.in Last Message By anisa	6 152,302
	Triggers in SQL SERVER. ( 1 2) 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... By Obaid Last Message By watson88	12 211,158
	Tuning an SQL query ( 1 2 3) 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... By sameer_havakajoka Last Message By mitzanu	20 7,775
	Concatenating data with Multiple Result(s) using FOR XML PATH 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... By mail.yuva	0 2,539
	CUBE function in SQL Server 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), ... By mail.yuva	0 3,176
	Basics of Stored Procedures 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... By Safari Last Message By kumarmannu	6 9,959
	Parsing technique in sql server 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... By venkatesanj@hcl.in Last Message By technica	8 10,825
	SQL Server Management Objects (SMO) : part 1 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... By sun_kangane Last Message By technica	6 17,250