Database – MS Sql Server How to estimate the amount of space that a query uses in tempdb? I am trying to join certain transaction tables that are really huge – about 300GB. Is there a way I can compute the space that the query might take in tempdb based on factors like: 1. Columns [...]
Answer Question | August 3, 2009 7:46 PM
Space allocation, SQL Server, SQL Server Data Storage, TempDB
Today I loaded Win XP. Some how I lost 38gb of memory. Looking in computer management I have 38gb unallocated space and only 2gb on C: drive. How do I get my memory space back? I am working in windows XP. This is on a Dell Optiplex GX270 comp. Thanks for anyhelp.
Answer Question | January 3, 2011 9:30 PM
Dell Optiplex GX270, Space allocation, Unallocated Disk Space, Windows XP
Does anyone have an opinion on using one over the other? I am familiar with RGZPFM and it’s benefits but am not familiar with the PF option of reusing deleted records…I would think it would be better to reorganize the file rather than reusing deleted records becuase you could have a lot of deleted records [...]
Answer Question | October 27, 2008 5:27 PM
DASD, REUSEDLT, RGZPFM, Space allocation
We are NDM’ing a file and running out of space. Is there a way to add a SPACE parameter to the control cards?
Answer Question | August 19, 2008 7:03 PM
NDM, Space allocation
How to change space allocation for already created PDS?
Answer Question | October 28, 2009 8:27 AM
Mainframe, Partitioned Data Sets (PDS), PDS, Space allocation