Viewing 15 posts - 37,411 through 37,425 (of 39,818 total)
You'd have to use scripting and ActiveX to create a reference to the package, then do a save. Not sure how you'd do this from a .dts file.
Steve Jones
July 25, 2002 at 4:17 pm
Not to discount the other work, but I'd capture all T-SQL and then drop into a table. Then delete the select statements.
Steve Jones
July 25, 2002 at 4:14 pm
you'd have to manually spool it, but your question was fragmentation. If so, you have to look at tables.
If you want free space, then that is by database, sp_spaceused
Steve Jones
July 24, 2002 at 4:01 pm
Both and no alerts on mem or cpu.
The cpu can easily peg for moments on a query and I don't want to know it. It usually resolves itself. If it...
July 24, 2002 at 3:50 pm
DMO might be the best way. There are articles on moving logins (and passwords), but there is also a DTS task to do this. To move the master stored procedures,...
July 24, 2002 at 3:48 pm
Generally they are not indexed. The underlying table indexes are used. If you do choose to index a view, then it builds this index and takes overhead to update it...
July 24, 2002 at 1:54 pm
Items like stored procedure work against the object_id for the table, not the name. If recompiled, they will fix the dependencies.
Steve Jones
July 24, 2002 at 1:48 pm
Show off your vast knowledge in areas that have no relation to the contract. Like football!
Steve Jones
July 24, 2002 at 1:47 pm
Only way I know is to load each and read the header. Probanly can use DMO to do this.
Andy?
Steve Jones
July 24, 2002 at 1:44 pm
Space (log and data) are always good. You might want deadlocks. Not sure I'd set many more without intending to watch for a specific problem.
Steve Jones
July 24, 2002 at 1:32 pm
dbcc showcontig shows fragmentation on tables.
Steve Jones
July 24, 2002 at 1:30 pm
SQL 2000?
You should be ok on the inserts. Is this 1M in a time frame? Per Day isn't too bad unless it's 500k one hour and 500k over 11...
July 24, 2002 at 10:39 am
Viewing 15 posts - 37,411 through 37,425 (of 39,818 total)