Your maintenance plans should be running under specific accounts, likely the Agent account, but you could set it to a particular account and then run Profiler for that particular account....

You can use DTS to do this, however you might want to import into a staging table, then update/insert into your regular tables.

You an also just link the Access tables...

3 Instances can be a lot, and you definitely want to limit memory. It might not be linearly, so not necessarily 1GB per instance, but you do need to leave...

And the Mariah, vertical windmill (darius or egg-beater shape) doesn't seem to affect birds. You have a relatively narrow impact zone as opposed to the large sweep of horizontal blades.

PacWind...

I've heard about the pumping of water, it's really a "gravity well", using current power to move something higher, creating potential energy, and then gravity to bring it back down...

I'll award points back to you, since the narrow minded US author (me) didn't think in terms of case sensitivity. I'll try to consider that for future questions.

The question has...

Try deleting the hyphen and re-entering it. Sometimes converting from SSMS to Word to our editor and HTML gets strange replacements for characters. I think this was one of...

You should look at the certifications and decide which one you are pursuing. The 70-431, which should get you an MCTS, is probably the first one you want.

I'd recommend picking...

Sounds OK. Couple questions

Where do backups go?

How much RAM to SQL Server?

Does the ERP system make heavy use of tempdb? Might need a R1 array for it and an R1...

As George mentioned, please post the code to let us see what is happening and then we can help.

Why would you set the recovery model to simple?

The above advice is correct. Log shipping requires logs to send to the destination server. If you move away from full...

Thanks. It was an interesting point that I hadn't seen made. And when I was in Redmond talking with the LINQ developers, I felt like they'd given up on that...

Thanks, must have cut and pasted the wrong query in there.

Corrected to be all.

Or CLR procedures. you can spawn threads inside one of those.

However why do you want to? You complicate things and if you have issues with your code, you could create...

You could use the data export wizard to create the files and then the data import wizard as well. It will create SSIS packages in the wizard that you can...