Viewing 15 posts - 16 through 30 (of 329 total)
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
July 13, 2015 at 8:16 pm
Jeff,
Thank you for the perspective. I like it and will remove the WHERE clause as you suggested.
BD
June 12, 2015 at 12:44 am
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...
June 11, 2015 at 7:00 pm
Jeff,
Again thanks for your insights.
edm2
January 26, 2014 at 10:06 pm
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...
January 26, 2014 at 4:36 pm
Alan,
Thanks for the great URL on triangular JOINS and an equally great solution.
BD
June 27, 2013 at 6:25 pm
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,...
June 27, 2013 at 8:07 am
Its seems more involved than using a cursor! I am reading the article slowly.
BD
June 26, 2013 at 8:41 pm
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...
June 18, 2013 at 7:59 pm
Thank you very much!
edm2
March 14, 2013 at 7:54 pm
>>> 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...
March 14, 2013 at 6:41 pm
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...
March 14, 2013 at 7:05 am
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...
March 13, 2013 at 11:46 pm
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...
August 28, 2012 at 10:01 pm
Viewing 15 posts - 16 through 30 (of 329 total)