Analyze it

Business Intelligence, Data wharehousing and Microsoft SQL Server services for BI Impelmentation SSIS , SSAS , SSRS

This Blog

About

Search

Navigation

Home
Blogs
Forums
Photos
Files
Reader
Roller

Syndication

RSS 2.0
Atom 1.0

Tuesday, April 15, 2008 - Posts

Truncation VS Deletion

when you try to empty the whole table especialy in SSIS DON'T use delete from [Table] cause it takes time untill the query runs and delete the whole table instead use Truncate table [table] cause truncation empty the table at once Read More

posted Tuesday, April 15, 2008 11:27 AM by wagdyIshac | 0 Comments