Hello,
I have questions about SQL Server and I hope you could help me a lot.
- Is it possible to reduce the size of my transaction log file during
the execution of a sql script ? Indeed, my sql script work with very
large table and my transaction log file use all the space on my hard
drive. so the script have to stop with an error.
- Is it possible to limit the size of the database tempdb ? I have an
another script sql who do an insert from a select with join (join
between 2 table of more that 24 Go) and group by. During the execution
of that script, SQL Server freeze, it doesn't progress anymore, and I
have to stop my process. So that is it possible that script works with
a tempdb database not larger than 24 GO per exemple ?
Thanks you in advance for your advice
K.
I have questions about SQL Server and I hope you could help me a lot.
- Is it possible to reduce the size of my transaction log file during
the execution of a sql script ? Indeed, my sql script work with very
large table and my transaction log file use all the space on my hard
drive. so the script have to stop with an error.
- Is it possible to limit the size of the database tempdb ? I have an
another script sql who do an insert from a select with join (join
between 2 table of more that 24 Go) and group by. During the execution
of that script, SQL Server freeze, it doesn't progress anymore, and I
have to stop my process. So that is it possible that script works with
a tempdb database not larger than 24 GO per exemple ?
Thanks you in advance for your advice
K.