hi debbie

if u r sure that the format(including the length) of the filename will not change then this shud work

select

substring('GC_20060616_All_Demographics'

hi

Use the performance monitor to know how much memory is being consumed by sql server.

to know which processes in SQL server are taking more memory u need to use...

hi paul

thanks for ur explanation. i do know about differential backups and how to restore them. What i would like to know is why the size of diff backups increase...

hi

maybe is has got something to do with the "SET" options.. for ex SET ANSI_NULLS and other like options.

Thanks for ur points ... my backup is scheduled as a job.       

Thanks For ur suggestions Lynn..

db is in full recover mode.

Hi Hans

Thank You for your suggestions.

Have you created indices? An index can take up huge amounts of diskspace - There are indexes in the database but i have not...

hi

use the backupfile and backupset tables in msdb. i think these table should help you although i myself have not used them and dont know much about them. There are...

hi

Iam curious to know whether you have made any progress. Have you solved your problem or are you any where near to solving it?

hi

dont know whether the way u r doing things is correct. i have a suggestion that may help you.

Instead of trigger starting the job let the trigger write the required data...

hi

have u opted for restricted growth for the files in the filegroup.

hi

r u running both sql 2000 and sql 2005 in ur new box. Is there any other resource intensive software running in ur new box.

there are some topics in ...

hi

I have experienced the same problem

try these

1) exec sp_updatestats - Runs UPDATE STATISTICS against all user-defined and internal tables in the current database.

2) DBCC UPDATEUSAGE (0) - Reports and...

u can use the pivot operator if u r using sql 2005.

u may have to use some dynamic queries but i would like to think that this would be simpler.

hi

just give a alias-name(s) for the column(ID_FIELD) in the select statement of the view.

by the way why do you need to select ID_FIELD twice since u r joining on the...