Serverless SQL Pools 100MB temp table limit

Serverless SQL 216 MVP

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.

1 answer

PRADEEPCHEEKATLA-MSFT 78,576 Reputation points Microsoft Employee

2021-08-31T04:10:54.08+00:00

Hello @Serverless SQL ,

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.
Please sign in to rate this answer.
PRADEEPCHEEKATLA-MSFT 78,576 Reputation points Microsoft Employee

2021-09-01T11:59:19.563+00:00

Hello @Serverless SQL ,

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.

Serverless SQL 216 Reputation points MVP

2021-09-01T12:01:35.137+00:00

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

PRADEEPCHEEKATLA-MSFT 78,576 Reputation points Microsoft Employee

2021-09-02T03:00:44.133+00:00

Hello @Serverless SQL ,

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.

PRADEEPCHEEKATLA-MSFT 78,576 Reputation points Microsoft Employee

2021-09-06T09:04:59.553+00:00

Hello @Serverless SQL ,

Could you please help with the screenshot where the you can insert data into temp table greater than 100 MB?
Sign in to comment