No. Also, it is not a need - it is a recommendation.

RAID 10 striping will be pretty fast, but with a single array, you only have a single set...

A T-SQL script runs at the server. It cannot interact with your client tools on your workstation.

You want some kind of client-side macro ability in Management Studio. There...

As far as the second server as a standby - yes, you can mirror, log ship, and replicate between 64bit and 32bit servers in most cases.

As far as the log...

In simple recovery mode, the log files get just as much write activity as in full recovery mode. The log files are simply truncated automatically at each checkpoint.

So, it...

You could go either way. Normalizing your database is good, but can cost a lot of complexity. Balance the two.

That being said, comments are something that could be...

...and as I was writing, up popped that NOLOCK suggestion.

Make sure you really understand this option before using it. I have rarely seen it used correctly.

Is the table locked, a page locked, or a record locked? preventing a "dirty read" is what the database is supposed to do. While you are inserting, other...

I think you are looking for:

[font="Courier New"]SELECT FormCode, [State], Max([Time])-Min([Time]) AS TotalTime

FROM MyData

GROUP BY FormCode, [State][/font]

The clustered index is the actual table data. So, by specifying a file group for the clustered index, you have changed your partitoning scheme to put everything on the...

I guess I prefer to lay out data flows in a top-down tree format and you prefer this sort of everything-goes-everywhere havoc approach...

The data flow looks pretty good to me....

In your scenario, the package will run on your local PC.

You have a couple of options. RCmd or another utility will execute a command on a remote machine. ...

SSIS is not designed for and should not be used for processes that have to stop mid-stream and wait for user input.

Modify your package to use a package variable and...

These are page latches and are supposed to be there. SQL 2000 sp4 introduced these being included in the process reporting.

Ignore them.

It just happens I needed to use a merge join to exclude "Already Processed" records today. I have attached some screen prints of what I built.

It is pre-release so...

I have had good luck with the TableDifference component also.

I don't know if you have noticed the "case sensitive" option, but it is really nice to be able to turn...