[dba-SQLServer] Error Trapping and temp tables

Mark L. Breen subs1847 at solution-providers.ie
Tue Jun 1 07:47:22 CDT 2004

Hello Marty,

I love what he is doing, a great idea, I heard about the same concept a few
years ago when I worked on a project with the Honourable Mr Colby.

However, what I omitted to mention was that it was VB and SQL not Access,
although as the question was in the SQL group, I may possible be excused.

In the end, I read one article that suggested that temp tables in SQL server
are resource intensive, especially on RAM, so I decided to use standard
tables as these temp tables will be having large throughput of data, even
though they will hold very little data, 1 million records per month roughly.

Thanks again for the help,


----- Original Message ----- 
From: "MartyConnelly" <martyconnelly at shaw.ca>
To: <dba-sqlserver at databaseadvisors.com>
Sent: Monday, May 31, 2004 6:39 PM
Subject: Re: [dba-SQLServer] Error Trapping and temp tables

> You should create temp tables in a temp mdb. Saves on bloat among other
> things.
> See Tony Toews method
> http://www.granite.ab.ca/access/temptables.htm
> Mark L. Breen wrote:
> >Hello All,
> >
> >I am developing a db and intend to use a temp table. Before use I create
it and after use I drop it.
> >
> >However, because I fear it may somehow remain in the system, I would
prefer to do a
> >
> >If exists (table name) drop table name
> >
> >But it is not that easy with temp tables, as you know, so I was
considering using a vb function that attempts to drop the table, I can catch
the error in vb, I hope, and ignore it.
> >
> >Have you guys any better suggestions how to do this.
> >
> >Basically, I want to check for the existence of a temp table and drop it
if it exists.
> >
> >Thanks in advance,
> >
> >Mark
> >_______________________________________________
> >dba-SQLServer mailing list
> >dba-SQLServer at databaseadvisors.com
> >http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> >http://www.databaseadvisors.com
> >
> >
> >
> >
> -- 
> Marty Connelly
> Victoria, B.C.
> Canada
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com

More information about the dba-SQLServer mailing list