|
Home > Archive > MS SQL Server > March 2006 > Change temporary tables location
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Change temporary tables location
|
|
| Ravi Ambros Wallau 2006-03-08, 8:23 pm |
| Hi:
I was wondering if it is possible, in SQL Server, change the database
where temp tables are generated by default.
I know that temp tables are generated on tempdb, but this is very bad
when there's much concurrency...
I need some "magic configuration" that allows me to specify the
temporary tables location for each database, like in Oracle.
Is there anything like that in SQL Server?
Thanks,
--
Ravi Wallau
nospam@nospam.org
| |
|
| There magic is anywhere else, but not in this settings of SQL Server.
HTH, Jens Suessmeyer.
| |
| Retrograde 2006-03-09, 7:23 am |
| As far as I am aware there isn't a way of doing what your asking inside SQL
Server
--------------------------------------------
Retrograde
"Ravi Ambros Wallau" wrote:
> Hi:
> I was wondering if it is possible, in SQL Server, change the database
> where temp tables are generated by default.
> I know that temp tables are generated on tempdb, but this is very bad
> when there's much concurrency...
> I need some "magic configuration" that allows me to specify the
> temporary tables location for each database, like in Oracle.
> Is there anything like that in SQL Server?
>
> Thanks,
>
> --
> Ravi Wallau
> nospam@nospam.org
>
>
>
|
|
|
|
|