When you open the package it opens the DTS package flow and the steps are visual. If you want to see the steps in detail double click the visual item...

Great article. Fortunately I have not come across this yet but always keep this type of info around just in case.

For me the biggest issue has been mainframe files where...

Actually it is inacturate to state a Where clause in an outer join is a filter applied after the join takes place. Try this on the last example:

select *

 from a

 left...

Keep in mind the query is run thru the interpreter before it actually executes and many times the query is reformulated to the overall condition.

In you last examples the...

Although the article is decent, it sets up expectations immediately that it cannot meet.

1) The title implies new knowledge that isn't common, but in fact I have been doing this...

Actually not sure about the 80% value but there is a threshold in which statistically the index will not be a value. But in your example you mention M, F,...

Just to throw in here.

First the keys are no matter what you should never use a word consdidered profain event if the interviewer does it. Quite simply put many interviewers...

http://www.microsoft.com/presspass/press/2004/oct04/10-19multicorelicensingpr.mspx

Was that with SQL 2K 64bit and Windows 2003 64bit. I have not seen in degrading in performance from anyone else and am curious about this. The only known issues...

Yes I do agree there, it however is far better for portability and the ability to split work between multiple servers to use the GUIDS but of course are not...

Are you storing your data in a char field?

I question because datetime fields are better to use for storing this information and in a decimal format of 4 bytes (date)...

A lot of the answer depends on your design of the database(s) but for the sake of hardware (if you haven't purchased yet) consider the following.

Get a system that supports...

Are you sure the job has ended. I have seen this when a job is still executing that the last success will not show until you show steps. Make sure...

There are also knonw issues with the virtual logs within the log file in SQL 7. MS for some reason never really corrected the issue in any service release to...

To my knowledge there are no known issues outstanding with HT on P4 processors relating to SQL. But you really won't notice a bennifit until the CPU hits above 80%...