The big thing missing from Aaron's blog is the code he used for each test. 😉 Didn't see much on accuracy, either...

I agree about the MONEY datatype, though......

What an amazing article! Covers most everything from womb-to-tomb for such an "impossible" delete. I remember being amazed when Barry first posted his solution on the original thread....

My first program was plugging wires into a "program board" for unit record equipment way back when there really were things like bit-buckets. Heh... might be dating myself there,...

Uh huh... that's why I wanted to see the commands. And, I'd like to see the DDL for the source and destination tables, as well.

Jack Corbett (8/4/2008)

---

You can use sp_msforeachdb and set @command1 to "Select table_schema, table_name, column_name, data_type from infomation_schema.columns".

[font="Courier New"]sp_msforeachdb @command1 = 'Select table_schema, table_name, column_name, data_type from INFORMATION_SCHEMA.COLUMNS'[/font]

Here's an article about...

Heh... I just can't bring myself to use something that has a cursor in it like sp_msforeachdb does in the presence of VARCHAR(MAX)... 😛

--===== Code to return all table names...

I'll just bet a plugged nickel that there isn't an IDENTITY column in the table...

CREATE TABLE #MyHead (RowNum INT, Something VARCHAR(20))

INSERT INTO #MyHead (Something)

VALUES ('Test row')

SELECT...

Heh... I just saw this code posted on our very own forums as part of some dynamic SQL... link withheld to protect the guilty... 😉

,CASE schedule.[letter_box_yn] WHEN ''Y'' THEN...

n.yarramreddy (8/4/2008)

---

I have a table having some 80,00,000 records when i performed bcp out i have extracted all rows and when i perform bcp in on the same table some...

Very nicely done, Andy... great walkthrough on what to look for and when it takes affect.

You bet. Thank you for the feedback.

Carla Hepker (8/4/2008)

---

Jumping in...

I assume each debit and credit is associated with a user identifier and has a post date time stamp. If that is the case, it seems to...

Understood, but not exactly what I meant... I meant what they do behind the scenes to generate the running total... must be a "machine language" cursor of sorts to get...

Actually, Gus' answer is the best answer... "It depends". This is the kind of thing that you need to test.

Gus, good point about the net gain on things like...

Ah, thanks...