I strongly favour the loopbased solution for this limited task. It is concise, readable without any comments and done quickly.

It performs well enough.

DECLARE @i INT

SET @i = 1

WHILE (@i...

My manager once explained to me that for most people, a database is just an imaginary magic big black box. A chunky piece of expensive hardware that they expect to...

This year I had to rewrite some SQL consisting of >7000 lines of code embeded in a DTS package, producing a huge table (> 160 cols, 1,7 million rows). The...

Press F1 and search Books Online for "log shipping" - for just getting the fresh data at some interval, a scheduled job with a SSIS package doing the transfer should...

Often when I find myself struggling with inconsistent data, the best solution is reducing granularity until the inconsistencies drop under the threshold. So less data can be more if chosen...

Talking mostly german at work, I am used to say think and write S-Q-L.

SEQUEL sounds too funny and they might think its a word I made up unless I pronounce...

Hi - that depends on the size of the indexes that need to be recreated, also filesystem fragmentation can play a role (a defragged filesystem speeds that up a bit)....