This one: http://www.sqlservercentral.com/articles/OpenDataSource/61552/

Mark,

Thanks and I understand the reasons, but it's still something that I never have come across in the SQL Server documentation. I wanted to point it out to be sure...

I'd probably use some type of replication to move data around, but I'm more comfortable with that. If you're comfortable with Perl or DTS, use that.

You need to track down...

If you have DB1, DB2, DB3, I'd recommend you create a view for each table.

In DB1, create view db2Employee as select * from db2.dbo.Employee.

Also, create view db3Employee as select *...

The bigger issue I think is that you haven't provided any abstraction layer for performance tuning and you're not taking advantage of the power of SQL Server. Stored procedures can...

Usually a group by has an aggregate in it (SUM, COUNT,etc). Otherwise you're not really grouping by anything.

No hammers or nails needed. Just $20-25 for tokens at the batting cage. Get a nice 34-incher.

OK a few grammar items so I'm sure we're communicating.

You have a database "ON" a system. It can be set up to automatically take a backup "TO" itself, meaning copy...

It is possible the stats are out of date for the insert, but that won't matter. They aren't used for an insert. They're used on the next SELECT. Running stats...

You are running from the "Binn" directory? Other commands work, like "dir"

What about just running "sqlservr"

I haven't seen much in my list of blogs (50-60) that I check. There are some good entries with Craig Freedman, but seems to be 2005.

I don't think there are...

I'd look to split these out. You can build a bigger box, but if you have issues, especially runaway queries, then it affects a lot of clients. Better to limit...

My vote is detach, attach.

I hear great things about the Apex Editor and SQLPrompt from Red Gate.

If you have a nice budget, Erbarkadero has a nice modeling tool if you have a use for...

I'd run Profiler, grab the most often run queries, and start dissecting what they mean and how the data relates. Most often run queries mean you'll deal with that data...