Look up the topic "Linked Server" in the Books Online. That will get you started.

Try running Profiler over that same period of time. You'll see what exactly is getting called. Be sure you capture before & after the event in case a process runs...

You might wait a bit and see if anyone else posts anything else interesting here. You are working in an area where there is room for interpretation and others might...

Indianrock (3/17/2008)

---

Agile development has arrived at my company. If you research this topic you'll see a tendency to either try and work without a DBA, or require a new...

Yeah, that's a lively set of responses.

One thing that did come up over there that I should have raised, what are you using the schema's for? Is it to seperate...

Someone might know the answer, but the forum here is for Microsoft SQL Server 2005. You'll more likely to get information by posting that question at a forum for the...

You're going to hate this answer... It depends.

I think it really depends on the definitions of the tables. I also think different people are going to have different approaches. For...

Sure. Sorry I couldn't help.

You might run into problems with those non-ansi joins too.

Instead of "FROM X, Y WHERE X.Id = Y.Id" you would use "FROM X INNER JOIN Y...

It's just a server with databases on it as far as normal operations are concerned. You shouldn't have any issues of any kind running a restore.

Amit Tiwari (3/14/2008)

---

Hi Everybody,

I have a table having Five Columns

CREATE TABLE TABLE_X (

Col1 INT NOT NULL,

Col2 varchar(10) NOT NULL,

Colc Datetime NOT NULL

)

PRIMARY KEY CLUSTERED IS ON COL1 & COL2.

THERE is...

WILLIAM MITCHELL (3/14/2008)

---

Grant,

Since the status column is an int, I am guessing that there is a table of statuses that gets joined on the status column, so I would think...

Wallace Wood (3/14/2008)

---

As a contractor for the $$$ I have been paid I would clean up the person's yard. Large canids in extent not withstanding.

Given that this is a...

I served mainly on pretty small boats & ships (short time on an LST) so I didn't see any of the crews I worked with die. Considering some of the...

What do your execution plans look like. What kind of indexing is on the table.

While 16 million rows is not small, it's not so outrageously large that you can't...

Really? They feed that crap to people? That's nasty. I'm glad I'm not too bipolar (shut up... no you shut up... shhh, they can hear us).