One of the reasons I am looking into file backups is because our database is used for data warehousing and data is loaded strictly in chronological order and never updated....

DBCC showfilestats (-1, -1) reports usage for all files in the current database (in extents).

Set a limit on the max file size of the current file to force all your data to the

new file immediately.

I am curious of new log file usage. Since it...

Rebuilding the clustered index with Sort_In_Tempdb has improved the

logical contiguity tremendously for me. Be sure to do the Drop Existing

if you have any non clustered indexes. Search BOL for "tempdb...

Is it something like,

Alter table Test add constraint Test_CK Check

Column1 in dbo.udf_GetParentTableKeys ()

Do you have an example? Does this perform better than a trigger?

Thanks.

This procedure shows history between two runtimes. I am looking for something that would show

the jobs sheduled to run between provided timeframes in the future.

I appreciate your time.

Thanks.

I had the same problem, when I was trying to retrieve the backup job history for all our servers. Apparently

when one of the remote servers is not available or login...

I was hoping this would work:

SELECT * FROM OPENQUERY (BIGDB, 'DBCC showfilestats ')

But, doesnot.

I get:

Server: Msg 7357, Level 16, State 2, Line 1

Could not process object 'DBCC showfilestats '....

That works great. Thanks you.

It is interesting I needed to run it a couple of times to get it to 0% fragmentation.

I would prefer to get the old partitions as...

Thank you. That supports the additional testing I did. Do you know how to

explicitly code for ROLLBACK if the proc execution is cancelled?

thanks.

That just works perfect.

Thank You All.

I would schedule for frequent log backups during the optimization job.

I would schedule for frequent log backups during the optimization job.

With the batch size configuration, I can limit the #rows in my transaction, thus if the batch fails only the inserts in that batch are rolled back. I do have...

Thanks to mom, gljjr and erasmusj for your replies, they would definitely work. But consider the situation where I do not have a PK, or my primary key consists of...