Gary Noter (7/28/2008)

---

Uhmm, Jeff, moi post was humor; or did I miss that you didn't miss the humor, or did you miss the humor (or are we now in a...

You bet... thanks for the feedback, Micheal. 🙂

The "Unexpected end of file errors" may be something that you have to put up with if the data file has crud at the end of the file. That,...

Thanks for the kudo, Grant. 🙂

Thanks again...

You keep saying that a "ROW" returned about 1MB of data... what is a "ROW" in this case?

Good example of an Insert... that's not inserting into a scalar variable, though.

I was looking for Avinish to provide the code example since he also made the suggestion with no code. 😉

Interesting, indeed. I'm curious... what do you mean by "1mb per row"? Do you mean that you calculated that you have to "touch" 1MB to process each CDR?

I'm probably a bit predjudiced, but I like the following article a lot better... 😛

http://www.sqlservercentral.com/articles/T-SQL/63003/

Thanks for the feedback...

Are these records "CDRs"? Does the billing process have anything to do with telephony, DSL, or VoIP?

And, when you say it returns 1 to 7...

Seems to be the max memory thing was what most of the problems I read about were... it's a good idea to set that even on a 32 bit machine,...

You already have a true whole number function and it works well. The only problem is with how you tested it... you've passed a numeric value to the function...

SQL Noob (7/25/2008)

---

what problems? we've been using for a year and it's been OK

if it wasn't for 64 bit SQL we would have to go to 64bit Oracle because the...

Try this, Michael... It's not done yet, but it'll do what you want without hitting up xp_CmdShell....

CREATE PROCEDURE dbo.GetDirDetails

/**************************************************************************************************

Purpose:

Replacement code for the sp_GetFileDetails proc that was available in...

GSquared (7/25/2008)

---

I was wrong.

Just tested it. Transactional replication from one instance to another. Updates, inserts, deletes, all transfer successfully (and immediately).

Truncate gets this error:

Msg 4711, Level 16, State...