Hi, according to the Microsoft documentation when using temp tables within Serverless SQL Pools there is a size limit of 100MB. Can this be confirmed please as I have been able to insert a much larger dataset.
Hi, according to the Microsoft documentation when using temp tables within Serverless SQL Pools there is a size limit of 100MB. Can this be confirmed please as I have been able to insert a much larger dataset.
Hello @serverlesssql,
Thanks for the question and using MS Q&A platform.
Yes, there is a total size is limited to 100MB in temporary tables in serverless SQL pool.

For more details, refer to Temporary tables in serverless SQL pool.
Hope this helps. Do let us know if you any further queries.
Please "Accept the answer" if the information helped you. This will help us and others in the community as well.
Hello @serverlesssql,
Just checking in to see if the above answer helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.
Hi, yes I did see the 100MB limit in the documentation however I believe I was able to insert more that 100MB into a temp table
Hello @serverlesssql,
Thanks for bringing this to our attention.
Let me try to repro it and see if it allows to insert more that 100MB into a temp table.
Hello @serverlesssql,
Could you please help with the screenshot where the you can insert data into temp table greater than 100 MB?
6 people are following this question.