Yes, it does have 3 parts. I will try that.

Thanks again!

-webrunner

Thanks for your reply.

Here is the command I used to create the linked server:

EXEC sp_addlinkedserver 'ADSI', 'Active Directory Services 2.5',

'ADSDSOObject', 'adsdatasource'

GO

Then I tried this query (domain changed for confidentiality):

select...

Good question if only because it made me realize that these links in SSMS query code can be activated at all, which I never knew before.

- webrunner

Great question. I got it wrong because I didn't know about the implicit conversion of string values containing only numbers.

For example, this code throws the error I expected:

declare @a int

declare...

That's ironic. Although in this case, I...

dbaInTraining (3/11/2010)

---

Not only do I think that it is useful, even necessary to have more than one article on a topic, I think it would even be helpful to have...

I think there's always room for a better explanation. There's even a web site devoted to the challenge of explaining things better: http://betterexplained.com[/url]. And, of course, there's How Stuff Works,...

Hi Steve,

What sorts of improvements do...

That reminds me of a joke I tell myself. No doubt I'm...

Thanks, everyone, for your help. I think the all of the advice points to not rushing to request the RAM right away, but spending some more time analyzing the performance...

Thanks, Jeff,

Yes, I suspect code and database design (including indexes) are probably the bigger problem, but I want to be able to quantify the severity compared with the (at least...

Thanks, Michael. Schneier's comments...

*clink*

Forgive me the indulgence of replying "cold" - I normally read through as many of the existing comments as I can, but for now I want to make one quick...

Lynn Pettis (1/20/2010)

---

To all those who are expecting PRECISELY CORRECT ANSWERS, how about putting yourself out there and submit some questions. The answers may not have been precise, but...