Ed Wagner (4/6/2015)

---

Eirikur Eiriksson (4/6/2015)

---

GoofyGuy (4/6/2015)

---

If you host my data, and your building burns down, including all backups, I don't have any data. Therefore I don't own anything, you do,...

Grab a copy of dbMonitor, connect it to the server and make certain that it is capturing...

pveilleux (4/6/2015)

---

Eirikur Eiriksson (4/6/2015)

---

pveilleux (4/6/2015)

---

It was not running. The 2005 server is a production server and the...

GoofyGuy (4/6/2015)

---

If you host my data, and your building burns down, including all backups, I don't have any data. Therefore I don't own anything, you do, even if you only...

pveilleux (4/6/2015)

---

It was not running. The 2005 server is a production server and the 2012 instances (sql101,...

Get what you are saying, thought that since "EMISATT" is...

pveilleux (4/6/2015)

---

Eirikur Eiriksson (4/6/2015)

---

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...

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,...