Good evening In a PROduction System the largest tables have for about 500M of rows and moreThe problem arises when we need to debug the oldest data from 1999 to 2006

this processes entails a time comsuming time process becasue before deletng the rows from a specficic range i.e from 19960101 to 19960131 w need to backup and deleting the specific rows takes so much time even though i use PK keys

According to your knowledege adn experience id like to know it its worth an pratical to implement particioning to those tables in SQL 2K and the deleting the partition in order to free up space in FG becuase theyre running out of space?Im not a DBA nor a developer but i wonder if this process needs a manteinance window ?Thnks in advanced

sorry, by mystake i pressed the enter key so the message was not completed, but the question is the partitionig process takes so much time ? what factors should be taken before starting this process ? the purpose of implementing partitioning tables in SQL 2K tables is to minimize the debug process so instead of deleting rows for huge tables i would delete the partition and that would be faster in order to free up some space faster, may you can correct me if im wrong ?ie i´ve got this table with the output sp_spaceused:name|rows|reserved|data|index_size|unusedSALDOS_PREPAGO_DIARIOS_ALTAMIRA_SALDOS|2147483647 |863440848 KB|541344904 KB|233418456 KB|88677488 KBthis has a column called:FEC_SALDO|smalldatetime|no|4| | |no|(n/a)|(n/a)|and the index:index_name|index_description|index_keysIX_FEC_SALDO_SALDOS_PREP_DIA_ALTAMIRA_SALDOS|nonclustered located on INDICES|FEC_SALDOid like to start partioning ths table by month

excuse me i didnt understand your question, what do you mean exactly when you say how is distribution of data based on the values?it has something to do with the Filegroup for allocating the table and its indexes ?thanks

excuse me i didnt understand your question, what do you mean exactly when you say how is distribution of data based on the values?it has something to do with the Filegroup for allocating the table and its indexes ?thanks

I was asking on amount of data for each of partitions. Are they in same order of magnitude?