I have used it extensively and all you really get is a few templates and Management Studio.

SQL 2008 has a GUI for a couple of things, but it is still...

I am not sure what you meant by this:

[font="Courier New"]But it will be good if my next statements will be based upon that field.

Then it will improve the perfomance...

right?? [/font]

but...

That's a lot of connection managers. I assume you have lots of other objects in the package as well. How much memory is visual studio using to just...

Yes, it will impact the server.

Most performance counters have a minimal impact, but best practice is probably to collect data from performance counters only when you need to.

Performance will not make a difference, but they can return different results.

If the field you reference when not using * returns all NULL values, even if there are rows in...

Look in Tools -> Options

You can configure a limit to the number of characters returned in Management Studio.

If you right-click on the replication node in object explorer, you can generate a drop script that may help you determine if everything has been cleaned up.

That is where the correct solution comes into play. At that company, you have a pretty good argument to have a near real-time copy of the database available for...

A bulk insert is a single transaction, but transactional replication does it's inserts and updates one row at a time in a single transaction:

BEGIN TRAN

EXEC spInsertRow...

EXEC spInsertRow...

EXEC spInsertRow...

EXEC spInsertRow...

COMMIT TRAN

Don't...

Replication uses stored procedures to do inserts, updates, and deletes on the subscriber. Check the procedures for this table to make sure they do not have data type problems.

I don't think I would name a table MyTable, but ok.

Is the Day field indexed? An index on just this field should make the query much faster.

I would, however,...

Turn on logging in your package to capture errors. If you just right-click in the background of the control flow you will find the logging options.

The SQL Agent will...

Fight! Fight!

I actually think the query governor in SQL 2008 will give people a false sense of security and be completely mis-used.

Configuring a proper environment and training the...

You misunderstood - use a MERGE rather than the UNION ALL.

It will union the data sets and leave them sorted. It will, however, only take two inputs.

The only fool-proof way to is restrict the users and developers from querying the production system.

As unrealistic as this sounds, it is relatively simple to configure log shipping or replication...