Gianluca beat me to it, but this is straight from BOL (Create synonym).

Assuming you didn't reverse the db and server in your question, this should work :

EXEC sp_addlinkedserver '06dw';

GO

USE...

MelS-512196 (6/16/2010)

---

Since all the "big guns" are posting on this thread, wonder if I could get some thoughts on a design I am contemplating. We will have multiple sites,...

scott.pletcher (6/15/2010)

---

Jeff, you can over-engineer, I'll give you that. Huge amounts of wasted I/O to no purpose. But you feel good about it, and obviously for you that's...

Easy, kick off the job that loads the data during the week-end at 4 PM friday rather than "off" hours. :hehe:

Jeff Moden (6/12/2010)

---

David Portas (6/12/2010)

---

Maybe you are getting confused because you are asking the wrong questions. First determine what keys make sense from a business perspective. If you are thinking...

100% correct with the exception that you need select *...

UMG Developer (6/11/2010)

---

lmu92 (6/11/2010)

---

I second Ninja's_RGR'us recommendation regarding the script screenshot.

For two reasons:

#1) it requires at least a little more effort to run it before answering (for those who...

webrunner (6/11/2010)

---

cathy.baker (6/11/2010)

---

No matter if it's a bad question or a trick question. The answer is one. The question was "How many records are returned from the last...

:w00t:

That avatar photo is a bit misleading... Gail is well, more of the female type 😉

Just my 0.02$, I don't care about the points but I fail to see the learning opportunity (for me) here. Like hugo said, you'll get an error as soon...

SELECT MAX(CASE WHEN Flag_a = 'y' then DateA ELSE NULL END) AS Datea

, MAX(CASE WHEN Flag_b = 'y' then Dateb ELSE NULL END) AS Dateb

, MAX(CASE WHEN Flag_c = 'y'...

Remake the plan would be an obvious one. Assuming you are able to edit the plan, then maybe add a db then take it out again should regenerate the...

james.massey (6/8/2010)

---

Ninja's_RGR'us (6/8/2010)

---

How much rows (in % of the total rows in the table) are returned by those 1-2 cases?

Are those rows returning more data than the other correct cases?

How...

Well just to be sure.

What I understand is that 99.9% of the queries, the plan is an index seek. However with a couple cases you get a...

How much rows (in % of the total rows in the table) are returned by those 1-2 cases?

Are those rows returning more data than the other correct cases?

How are the...