2/18/2023 0 Comments Oem partition running out of space![]() ![]() This is the code that ends up eating all my disk space. ) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = ON, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON () )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = ON, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON () WITH ( ONLINE = OFF )ĬREATE NONCLUSTERED INDEX ON. ![]() ![]() ![]() )WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON ()ĭROP INDEX ON. Is there a way of batching the process? USE ĬREATE CLUSTERED INDEX ON. The issue I am having is when I try to assign this table to be partitioned I'm running out of disk space. There is no clustered index currently on the table, there are 2 Non clustered indexes around the time the log was created and the ASP Session ID that has been pulled from the data. There is one file in each file group and one days data goes into each file. The partition Scheme and function split the table into the relevant day. It contains data from IIS logs that have been generated over the last 70 days. I'm trying to parition a large table ( 160Gb). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |