the sqlist (8/11/2011)
the sqlist (8/11/2011)
amir.mochtar (8/10/2011)
i created #tmp table when processing large of rows then i made index for some columns, those are often used in inquiry. Did i do right?The only problem with the indexes on temp tables in stored procedures or scripts is that they are not given by the SQL engine unique names as in the case of temp tables themselves. So if one connection invokes a procedure or script that creates a temp table and then its indexes, a second connection that will try to do this at the same time will fail because the indexes were already created by the first one. Remember, objects in SQL server has to have unique names.
I will have to retract that. You actually can create indexes with the same name but on distinct tables.
No issues with temp tables indexes.
yeah, thanks.
i got error that you mention earlier, i didn't realize the error will show in second connection, i put in foreachLoop component. i was planning to create hole process in ssis package that will be run in sql agent.
by the way, do you know where should i implement begin trans, commit, and rollback in package data flow? if in store procedure, i could easily implement those transaction keyword.