Thanks everybody, I hope everything goes fine!

GSquared (6/30/2009)

---

Gianluca Sartori (6/30/2009)

---

GSquared (6/30/2009)

---

I read and mostly understood Frank Herbert's "Dune" when I was seven. I've been playing with the English language ever since, and it's quite a...

Looks like you changed your query from linked server with 4-part names to openquery. In the first case the query is run in SQLServer against data residing in Oracle, in...

I can't answer this question, I just link the same question in SQL 2005 if someone knows how to do it.

http://www.sqlservercentral.com/Forums/FindPost744460.aspx

Gianluca

Unfortunately I don't know the answer, I'm here just to link your post in the sql 7,2000 forums, so that if someone knows the answer for SQL 2005 maybe could...

I come across this kind of issues almost daily, since I'm working on a SQL Server app that reads data from AS/400 with linked server queries. It wasn't me to...

Could "Install SAP" be an answer?:-D

GSquared (6/30/2009)

---

I read and mostly understood Frank Herbert's "Dune" when I was seven. I've been playing with the English language ever since, and it's quite a toy! Not...

Lynn Pettis (6/30/2009)

---

Gail, you'll like this one. The OP wants us to use our crystal ball to help solve his problem.

Don't know about you, but mine seems to be...

With this little information it could be anything...

What have you done so far to catch the bottleneck?

Did you try to catch long running queries with profiler?

Did you run...

This is one of the reasons why clustering for SQL Server is a useful feature, but not as useful as one would expect, at least one who has worked with...

GilaMonster (6/30/2009)

---

Can someone send me a PM please. There looks like there's something buggy, every PM I've received in the last week has been from 'Anonymous' and has no profile...

That's exactly what I had to do for that DB...

It's possibile, but I...

... if so it must be called. Is it the right word?

GSquared (6/29/2009)

---

2. You include columns like FirstNameID, LastNameID, and reference a Names table. If you need to find everyone named Fred, and the ID for Fred is 6, then...