Estimate SQL Server tempdb space for a query
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

Unallocated Disk Space
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

RGZPFM vs Reusing Deleted Records
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

NDM and SPACE
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

changing properties of PDS
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