Sounds crazy but we had restored 4 year old DBs hunting for the first monthly appearance of a certain data value in a column

BD

Jeff,

Thank you for the perspective. I like it and will remove the WHERE clause as you suggested.

BD

Jeff,

You are absolutely right. My query will be used to create a report for the Operators group to check the daily sql runs jobs. I too have some jobs that...

Jeff,

Again thanks for your insights.

edm2

Jeff,

Thank you for your thoughtful answer. They were annoyed because we had a general DB plan laid out, as presented in "review meeting 1", but because of several "surprises" encountered...

Alan,

Thanks for the great URL on triangular JOINS and an equally great solution.

BD

I had never heard of a "triangular" join but I verified it is incredibly slow. . (I actually took the very data involved, exported it to a CSV file,...

Great idea. Thanks.

BD

Its seems more involved than using a cursor! I am reading the article slowly.

BD

DeWayne_McCallie,

>>>>I usually stop SQL and make a copy of the system DB's as an extra backout option as copy/paste is easier than restoring the system DB's

Ha! I didn't think of...

Thank you very much!

edm2

>>> but it generates SQL that corresponds to the Flat File definition.

I didn't know that. Where is it hiding? Must be the .dtsx package....let me look.

edm2

P.S. We don't let the...

A few points:

1. Yes, these are fixed width files. The main annoyance I encountered is that SSIS would not let me define all the connections in one shot. I had...

I figured out a way. I used the Import\Export Wizard under SSMS to export the contents of an empty table to an empty file and Saved the resultant package. (Unfortunately...

Jeff--

>>> You actually need to stop working and start teaching.

Another sterling idea that I will pursue. In the past when I tried to teach some elements of query tuning, the...