In case a file of X MB is loaded into SQL Server table,
need to find out how much space it occupies in SQL Server – is it < X or X or > X.
我的样品 test csv file(36 bytes)
我尝试将csv文件加载到sql服务器中时执行测试,将计算机上加载的csv文件加载到我执行的SQL服务器中时为36个字节
sp_spaceused '[dbo].[assign-test]'
像这样的输出
有人可以告诉我硬件来决定文件大小是否超过36个字节还是相同
There will be an increase in size ,example when a excel size of 20 KB is loaded into SQL server the file size is checked , there's an increase (file size + index size) so there always an increase when raw file is loaded (I tested it )
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句