Tips for using jobs in SQL Server 2008 (4/27/2011)
Tips for using jobs in SQL Server 2008
Run the scheduled jobs during periods of low database access.
To reduce the total SQL Server overhead, try to schedule SQL Server 2008 jobs during CPU ...
SQL CLR a new approach (10/31/2008)
Normal
0
MicrosoftInternetExplorer4
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso...
Automation and T-SQL (6/17/2003)
Automation and T-SQL
By Bill Wunder
T-SQL does 4 things well: select, insert, update, and delete. That’s not to say that you can’t write a select, insert, update or delete...
Yukon Delay (6/16/2003)
Yukon Delay...
By Alex Gray
Last week it was reported that Microsoft have announced that they are putting back the release date of the next version of SQL Server ...
Installing & Upgrading to SQL Server 2005 (3/23/2006)
Installing & Upgrading to SQL Server 2005 by Robert Pearl
Based on my attendance at SQL2K5 seminar on Installing and Upgrading, let's talk about what you’ll need to know before upgradin...
My First Experience with SQL Azure (7/25/2011)
My First Experience with SQL Azure
By Chris Shaw
There is so much news around the SQL Server world right now. If you haven’t been keeping up with it, you may be missing one of t...
[Msg]: RE: [sswug:sql2k] generate insert statement (12/18/2002)
Found the script in my archive... scripted by Nicole Welch
--Moorthy
CREATE proc sp_ScriptTableInsert
@DatabaseName varchar(500),
@ScriptSourceTable varchar(500),
@DeleteExisting int = 1,
...
DSNTEP2 aka Batch SPUFI (7/6/2006)
DSNTEP2 aka Batch SPUFI
by Craig S. Mullins
DSNTEP2 is an application program that can be used to issue DB2 dynamic SQL statements. It is sometimes referred to as “Batch SPUFI” because...
