Solomon Rutzky (4/6/2015)

---

Thanks Eirikur. Just FYI, the link you posted was wrapped in...

Sagar-636902 (4/6/2015)

---

it was blocking for more then 12 hours.. and which crazy that create triple thread block and re-org blocked 2 other process in chain.. since having large table i...

pveilleux (4/6/2015)

---

I also went ahead and disabled Named Pipes on sql102, tried the queries, enabled Named Pipes, tried queries again. Everything on sql102 is behaving just fine. ...

DonlSimpson (4/6/2015)

---

Grant Fritchey (4/6/2015)

---

I'll go one further. I'd suggesting taking a look at Jeff Moden's article on Tally Tables[/url] and using that to take the comma delimited list and turn...

pveilleux (4/6/2015)

---

I did not disable Named Pipes on sql101 because it is not disabled on sql102. From sql102, I can get to SQL2005INST no problem. In fact, from...

Quick thought, I have workstations with full install of all versions of SQL Server from 2000 to current, all of the installs were done in the order of the versions,...

With due respect, this is starting from the wrong end, one should not focus on technical but business quantifiable for overall quantities and sizes, from there its all either division...

Quick questions, can you post the actual execution plans for the two queries? Are the statistics up to date?

😎

There are quite few things that can affect this kind of query,...

Have you disabled Named Pipe and made certain TCP/IP is enabled? The error is typical of such an issue.

😎

Quick suggestion, try Adam Machanic's Who is Active

😎

Ed Wagner (4/6/2015)

---

Eirikur Eiriksson (4/6/2015)

---

patricklambin (4/5/2015)

---

Thanks for this easy question because , to help a friend , I had to read both books from Kalen Delaney about the storage...

Luis Cazares (4/6/2015)

---

Or maybe you might need a LIKE in your JOIN clause.

SELECT

TB.DiaryID

,TA.MedicalCodeID

FROM dbo.TableA TA

JOIN dbo.TableB TB ON TB.EmisCode LIKE TA.EmisCode +...

Score

Quick question, are you using Full Text Search / Indexing?

😎

Act