SQL Server Tips and Tutorials

Learn how to Make Money Online doing freelancing, Affiliate Marketing, Blogging and many more ...

Go4Expert

Go4Expert RSS Feed

Search Advance Search Sitemap Newsletter

		Programming and SEO Forum > Go4Expert > Articles / Source Code > Database
SQL Server

Mark Forums Read

Post New Thread

Submit New Article

Copy HTML to Clipboard

Copy BBCode to Clipboard

| More

Tutorials and Source Code in : SQL Server

Search this Forum

	Views: 17,887 Announcement: Rules for Duplicate Article Submission 10-08-2008 shabbir (Go4Expert Founder)
		Rating Article / Author	Last Post	Replies	Views
		Stored Procedure in sql server venkatesanj@hcl.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...	05-24-2010 05:06 AM by LynxSI	4	14,486
		Tuning an SQL query ( 1 2) sameer_havakajoka 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...	12-28-2009 04:43 AM by rasd123	18	2,432
		Triggers in SQL SERVER. Obaid 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...	12-24-2009 01:09 PM by technica	5	24,900
		Basics of Stored Procedures Safari 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...	12-24-2009 01:07 PM by technica	3	2,368
		Parsing technique in sql server venkatesanj@hcl.in 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...	12-24-2009 01:05 PM by technica	8	5,759
		SQL Server Management Objects (SMO) : part 1 sun_kangane 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...	12-24-2009 01:04 PM by technica	6	6,759
		Audit Trail in SQL Server 2000 or SQL Server 7 shabbir 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...	02-12-2009 01:50 PM by shabbir	7	15,395

Post New Thread

Submit New Article

Copy HTML to Clipboard

Copy BBCode to Clipboard

| More

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search
Bookmarks
Add to del.icio.us Add to Google Digg it Add to Yahoo ! Add to Windows Live

	New comments		Hot articles with new comments
	No new comments		Hot article with no new comments
	Article is closed

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off

All times are GMT +5.5. The time now is 05:28 AM.