I have a 10 million records table that I need to reinitialize each week.
This table have 10 fields and an indexed primary key and when I do a "delete from myTab" the log going huge and It takes a while.
Is it possible to accelerate this (by specifiing any bypass mode)?
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs).
Being someone who is always looking for alternatives to "work your data", I came across this …