Join | Login | Why Join?   
SQL Server, Oracle, DB2, Sybase, MySQL Help - SSWUG.ORG HACKER SAFE certified sites prevent over 99.9% of hacker crime.
Search SSWUG:   

HOME

 
Register / Join
Login
 
Webcasts/Video Shows
SQL Server Conference
Watch SSWUGtv
Podcasts
Webcast Directory
Platforms
Microsoft SQL Server
Oracle Databases
IBM's DB2
MySQL Databases
For Developers
XML Technologies
Major Sections
Business Intelligence
White Paper Library
Product Directory
Database Script Library
FAQ System
Forums
Email Discussions
List Servers
Site Options
Employers: Post Jobs
Find a Job
Popular Articles
Browse Tags
About SSWUG.ORG
About SSWUG
Write for SSWUG
Request Product Review
Advertise on SSWUG.ORG
Contact Us
Other Resources
Office Users Group
MS SQL City
 

Editorial: Anatomy of a SQL Server Injection Hack on the Show Today
Read thoughts, experiences from around the world, hear about other's work with SQL Server and much more.   Read More...


Feature Article  |  RSS
Writing efficient Stored Procedures - A Case Study
(By G.R. Preethiviraj Kulasingham) Performance optimization of Stored Procedures for developers. This article is a case study, which re-writes a stored procedure in differnet ways in order to optimize the performance.



Other Articles by This Author

Tags: Performance, Optimization, Stored Procedures, Execution Plan, STATISTICS IO, Temp Table, XML
 
Past Articles  |  RSS
Troubleshooting SQL Server 2005 jobs (Part 1)
Oracle 2-Day DBA in x Days Post 6; Understanding Oracle's Networking Environment
New Data Source Controls in ASP.NET
Troubleshooting SQL Server 2005 full-text search
Oracle 2-Day DBA in x Days Post 5; Starting to use Enterprise Manager (dbconsole)
Microsoft SQL Server Content  |  RSS
Writing efficient Stored Procedures - A Case Study
Using Indexes to Bypass Locks
Policy-based Management in SQL Server 2008 – Part II
Column Order in a Composite Index
SQL Server 2005 Express Edition - Part 22 - Upgrading from Microsoft SQL Server Desktop Engine (MSDE)
More Articles For This Area
Free Articles For This Area
 
IBM DB2 Database Content  |  RSS
APAR Friday: Five for Friday
Information architecture essentials, Part 7: Data-store design
How to Write Efficient SQL (Part 2)
DB2 LUW Performance: Write I/O Optimization
Making DB2 Case-Insensitive
More Articles For This Area
Free Articles For This Area
 
XML-Related Content  |  RSS
Implementing SOA: Using Services
Improve the performance of your XML applications using Xerces-C++
Cross-site XMLHttpRequest: Boon or Pandora's Box
New XSD Functionality in Visual Studio 2008 SP1 Beta 1
Making Spring XML config better
More Articles For This Area
Free Articles For This Area
 
Oracle Database Content  |  RSS
Triggers…
Index Scan or Full Table Scan: The “Magic” Number (Magic Dance)
Oracle Enterprise Manager leverages multiple environments for pharmaceutical giant
Hyperion Data Integration Management 9.3.1 - Loading Data into Essbase Cubes using Type1
Data Warehousing: Exposing logical attributes with virtual columns
More Articles For This Area
Free Articles For This Area
 
Things You Should Know About
 
Developer-Oriented Content  |  RSS
.NET Tip: Sort an ArrayList Using a Custom Comparer Class
Save and Retrieve Images from the Database using ASP.NET 2.0 and ASP.NET 3.5
Real-Time Progress Bar With ASP.NET AJAX
Using ASP.NET Application Services in Windows Applications
Event, sit! Event, staaaay...
More Articles For This Area
Free Articles For This Area
 
Open Source Database Content  |  RSS
Teach Yourself Django in 24 Hours: Hour 2: Creating Your First Website
MySQL Proxy: rollbacked transactions
Testing InnoDB 'Barracuda' format with compression
MySQL Proxy: COMMIT obfuscator
How to estimate query completion time in MySQL
More Articles For This Area
Free Articles For This Area
 
Security-Related Content
Defend Your Site against Common Hack Attacks
Researcher Finds New Way to Hack Oracle Database
Correct the SQL Server Authentication Mode in the Windows Registry
Enterprise Data Management: Governing for Data Security
Reduce your exposure to AJAX threats

   






 

[ Register ] [ Webcasts ] [ Podcasts ] [ Newsletter Archive ] [ RSS/Feeds ]
[ About ] [ Advertise ] [ Contact ] [ Privacy ] [ Terms of Service ]
[ Link to SSWUG ] [ List Server Archives ] [ Recent Orig. Content ]
(c) 1997-2008, Bits on the Wire, Inc.  (0)

Some names and products covered by SSWUG are the registered trademarks of their respective owners.
DAA10354WWW004