Happy Day, Grant.

I looked for SFTP solutions as well for a process we use. Every provider wanted you to buy a suite of packages which really wasn't (isn't) cost effective for...

Hard to provide an answer to such a vague question. It would help to know more about the data so that we can provide an answer to your question.

Good luck Barry. May everything work out for you.

snowshoes

If Microsoft were to add a tempdb for each database instead of a single global tempdb, wouldn't it make sense to implement it as a separate filegroup that we would...

What is untenable about saying I'd need to do testing? Seems to me that's says I'm not sure and would do more investigating before commiting one way or the...

First, read what I wrote, I would have to do some testing to know if the in-line TVF would scale well or not.

Second, it really depends on how someone creates...

david_wendelken (3/13/2010)

---

Well, I've been using create or replace for over 10 years now.

I remember when I had to code in Oracle before it was introduced, and how much simpler the...

Paul White (3/13/2010)

---

Lynn Pettis

---

I would not store the total of the Invoice Lines in the Invoice Header record. This can be computed as needed when the header record is...

Index definitions alone are not enough. We also need to see the table definition (CREATE TABLE statement).

Not exactly sure what you are asking, so to help us help you, please read and follow the instructions in the first article i reference below in my signature block....

First of all, I would not store the total of the Invoice Lines in the Invoice Header record. This can be computed as needed when the header record is...

I'm waiting for the Average DBA Competition. I'll nominate myself for that one.

Paul White (3/12/2010)

---

It looked like spam to me...