Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
alejo46
Posting Yak Master
157 Posts |
 Posted - 2013-10-05 : 03:46:55
|
| Good Morning:Need your help,please according to your experience and knowledge?theres is a FG callled xx and it just has 1 % free space. there is no disk space to free up this FG and i cant not move objects to another FG Theres a table for about 750 millios of records and about takes up about 220 GB using sp_spaceused:HECHOS_TRAFICO_LLAMADAS_DATOS_SMS_SCL_201303 740933108 200623976 KB 200602496 KB 1128 KB 20352 KBThis table has no index , and the scenario is this:1.In order to backup this table there is a DTS that uses a script that extracts to a text file partioning this file in 5 chunks using date range i.e: SELECT * INTO TRAFICO1.dbo.HECHOS_TRAFICO_LLAMADAS_DATOS_SMS_SCL_201303_20130313_20130318 FROM TRAFICO1..HECHOS_TRAFICO_LLAMADAS_DATOS_SMS_SCL_201303 WHERE FEC_PROC >= 20130313 AND FEC_PROC <= 20130318Once the five parts of the whole table have been downloaded to disk we request a backup but the process for each range file takess for about 12 hoursSo i have a couple of questions that follow:1. if i created an index to the table HECHOS_TRAFICO_LLAMADAS_DATOS_SMS_SCL_201303 for column FEC_PROC the the sentence SELECT INTO * would use that index and improve performance ? if so how much would it take to create that index ?2.if i created the same index to the new table used in select into would improve performance because while extracting data using bcp tkaes a fill scan3. which more options would you choose in order to not to affect performance id appreciate your hrlp in advance |
|
|
|
|
|
Performance for Filegroups mainteinance