[dba-SQLServer] #Deleted-Problem (Cross-posted)

Francis Harvey HARVEYF1 at WESTAT.com
Tue Jul 6 16:57:33 CDT 2004


Michael,

I can't really add anything to the caveats about temporary tables from
sql-server-performance.com. I use temporary tables all the time, but
in a trigger... If you do decide to use it, let us know how your
performance turns out.

Francis R Harvey III
WB 303, (301)294-3952
harveyf1 at westat.com


> -----Original Message-----
> From: dba-sqlserver-bounces at databaseadvisors.com 
> [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf 
> Of Michael Brösdorf
> Sent: Tuesday, July 06, 2004 10:39 AM
> To: dba-sqlserver at databaseadvisors.com
> Subject: AW: [dba-SQLServer] #Deleted-Problem (Cross-posted)
> 
> 
> Francis, THAAAANK YOU!!!
> 
> Unfortunately I already started to go unbound, but guess 
> what: it's pain in
> the.. and I am more than willing to
> stay 'bound'.
> That solution is so simple! However, do you have any 
> information regarding
> performance implications (a new (temp) table is created every time the
> trigger fires)?
<snip>



More information about the dba-SQLServer mailing list