Viewing 5 posts - 1 through 5 (of 5 total)
Thanks all for your suggestions. Here's the actual spec. Forgive me if it might seem a little vague, but really i'm a developer, and not an expert on the hardware...
December 30, 2003 at 2:47 am
What a top bit of code. I'm all for the simple option (sp_msforeachtable).
Sean
November 12, 2003 at 6:11 am
Don't mean to be picky but have you thought of using the INFORMATION_SCHEMA.TABLES view to get the tables listing? This is based upon the sysobjects table but is the preferred...
November 12, 2003 at 2:18 am
The data warehouse that i work on is defragmented weekly, rather than having the indexes rebuilt. The reason for this is that calling DBCC INDEXDEFRAG produces less locking than DBCC...
November 12, 2003 at 1:58 am
If you are thinking of running this script from a job, or within a stored procedure then you might want to think about bcp. Check out BOL for exact syntax.
...
October 10, 2003 at 2:03 am
Viewing 5 posts - 1 through 5 (of 5 total)