Tips for using SQL Server 2005 stored procedures (2/27/2008)
Tips for using SQL Server 2005 stored procedures
Microsoft SQL Server 2005 introduces many new useful stored procedures, functions and operators.
Some actions you can perform without these new ...
Stored Procedures Administration (3/31/2004)
Stored Procedures Administration
Alexander Chigrik
alexander@sswug.org
Introduction A stored procedure is a precompiled collection of Transact-SQL statements stored under ...
Optimizing Stored Procedures To Avoid Recompiles (3/24/2003)
Optimizing Stored Procedures To Avoid Recompiles
One of the most overlooked areas in optimizing SQL Server and Transact-SQL is the recompilations of stored procedures. Recently started looking ...
High Speed Data Import Using Synthetic Keys (3/1/2010)
High Speed Data Import Using Synthetic Keys
by Ben Taylor
Synthetic keys are a common database design in SQL Server. A synthetic key is a system assigned value that has nothing...
[Msg]: [sswug:sql2k] Post SP2 Fixes (12/22/2002)
We applied Sp2 then moved to the post sp2 hotfixes and have a couple of questions for any of you that may be familiar with this. This is a brand new install with no databases yet.
We copied all the...
Troubleshooting Web Assistant Procedures (5/3/2006)
Troubleshooting Web Assistant Procedures
SQL Server supports the following four web assistant stored procedures:
- sp_dropwebtask - sp_makewebtask - sp_enumcodepages - sp_runwebtask
This art...