Gianluca Sartori (6/21/2010)

---

Paul White NZ (6/21/2010)

---

I'm no expert, but it seemed to me that Giorgio Chiellini flicked the ball on to Smeltz, not an...

Amazing how some people think that it is pessimistic to think that most developers understand the issues of using the NOLOCK query hint. After many of the discussions here...

Eugene Elutin (6/19/2010)

---

Lynn Pettis (6/19/2010)

---

Eugene Elutin (6/18/2010)

---

Ok, I assume that if the person used it, he knows what "WITH (NOLOCK) does, therefore it must be acceptable in their case.

I can...

Bad...

Steve Jones - Editor (6/18/2010)

---

Grant Fritchey (6/18/2010)

---

GilaMonster (6/18/2010)

---

Lynn Pettis (6/17/2010)

---

Don't you love it when some one PM's you for help? Just deciding if I should help, post it for...

I do have to point out I disagree with the use of the WITH (NOLOCK) hints in most of the queries presented on this thread. You all are aware...

TCP

Table DDL, sample data, expected results based on sample data.

Help us help you.

With nothing to test against the following is a guess:

select

count(distinct pmi.Id) as TotalPrograms,

count(pt.Id) as TotalViews

from

dbo.ProgramMetaInfo pmi

...

Steve Jones - Editor (6/18/2010)

---

Same media should mean it's not corrupted. I'm not sure if that's the log file, but I've seen SQL setup put a log file somewhere in...

Checked out a thread where one of my blogs was referenced, feels good when it helps someone solve a problem. 🙂

Don't you love it when some one PM's you for help? Just deciding if I should help, post it for others as well, or just ignore it. Decisions,...

Steve Jones - Editor (6/17/2010)

---

Did you check for a sqlsp.log or something like that in the Windows folder? I think setup logs stuff in there. Or is this from there?

Are...

Looks like Error Code: 2 my mean that the system cannot find the file specified, but which file?

Okay, in one of the logs I found a message indicating that I needed to be an administrator. That's nice, I am an administrator on that PC, so now...