Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. dspjkr

    Growth Planning

    I am attempting to calculate the amount of space that will be needed for our database for the rest of the year as well as next year. The end-users have provided estimates as to how the tables will increase in rows for the rest of the year as well as next year, from there I am able to calculate...
  2. dspjkr

    Free Space

    We have a table that is split across three dbspaces. When it was set up it was given a very large next extent. So when it grabbed the next extent it took the remaining space in all three dbspaces. Is there a way to show how much space is actually being used. The query I have shows the dbpsaces...
  3. dspjkr

    DTS Stored as file?

    My boss, gave the ok to have a test server re-loaded. He did not know that my DTS package was on there. Is there a file I need to look for on the system backup? Or can I restore this from some other way. Or do I have to start over? Thanks!
  4. dspjkr

    Table Extents

    I came across the below statement... "Monitor the number of extents per table with the following SQL. When a large number of extents have been allocated, schedule a time to perform preventative maintenance on the table. Theoretically, a table could have 200 extents, but realistically...

Part and Inventory Search

Back
Top