Hey all, sorry I fell off the earth a bit, even when I had an article go up. Thanks for the applause those who posted, and specifically to Koen...

Anipaul, what do you mean by sample questions here? I didn't provide any sample...

Thank you, glad you enjoyed it.

I do have what I hope isn't a 'stupid question', please. To be a competent SQL Server DBA, how good...

Peter Trast (5/9/2011)

---

One of the most important things I have done is to create and maintain a LinkedIn presence. I get so many inquiries because of that site. I have...

yan-160997 (5/9/2011)

---

Craig,

I have been working for a financial company for over 10 years as a system analyst. During those years I have managed many SQL server both in production and...

Insert SELECT, not insert VALUEs.

Jeff Moden (5/7/2011)

---

What I was thinking is that no Tally Table is necessary for this. I believe...

I take it me beating you with them until you submit...

Lowell (5/6/2011)

---

darn; i was guessing you were appending a WHERE statement...

ok how about the REPLACE?

this section:

Replace(URL.URL,'{0}',RTRIM(CL.ClientID)) as LOB_CompanyRecord,

uf Url.URL has one row, but CL.ClientID has multiple rows, that oculd cause...

bcampbell-1136357 (5/6/2011)

---

The only consistent element to this problem is that it only occurs when querying accross a linked server. Does anyone know of any limitations of querying linked servers that...

dsorensen 74234 (5/6/2011)

---

Thanks for links Ninja...

I was hoping to avoid running a trace but, if that's the only way to get the job done I'll do it. I probably should...

Easiest way for us to be able to help is to see the execution plans. If you need help pulling them, see the 'index/tuning' link in my signature.

My guess...

Probably not the cleanest way, but it'll get you going. I simplified the problem a bit:

DROP TABLE #tmp

GO

CREATE TABLE #tmp (somestuff VARCHAR(50))

INSERT INTO #tmp VALUES ( 'abc')

INSERT INTO #tmp...

What is the source datatype that you're extracting the information from? DATETIME?

I'd ask them to supply a whitepaper or similar official item on the subject, news to me.