Steve Jones - Editor (2/17/2010)

---

I have no idea what the pwd is, and don't want to know. It's someone else's responsibility.

I am thinking of setting up a recurring snapshot each...

Paul, the QOD does need a slight modification in verbiage.

Paul White (2/17/2010)

---

With an exclusive lock, no other transactions can modify data (except for operations with NOLOCK hint or read uncommitted isolation level)

What???!!! :w00t:

I want my point back!

Unless someone can...

Uh oh

I guess it's...

With it being 2U, I would hold out hope that you could add at least add more drives. There should be a couple of bays. For DR purposes...

Paul White (2/17/2010)

---

I also have a mobile phone - it's mobile, and...

Let's see, Raid 1 or no raid at all.

Raid 1 will impact performance. Having OS on same drives as database files will impact performance. Running Virus Scan will...

Jeff Moden (2/17/2010)

---

Hmmm... wait a minute. One more question to ask... in relation to the "fast" desktop server, where is the "slow" SQL Server? Here's what I mean...

Alvin Ramard (2/17/2010)

---

CirquedeSQLeil (2/17/2010)

---

Alvin Ramard (2/17/2010)

---

Well, looks like I'm gonna have fun over the next few days. I've decided to upgrade my laptop to Win7 - 64 bits. ...

Alvin Ramard (2/17/2010)

---

Well, looks like I'm gonna have fun over the next few days. I've decided to upgrade my laptop to Win7 - 64 bits. I love re-installing...

When running the query on the server, do you experience any cpu usage spikes? Are there disk io spikes as well during query usage?

What is the size of your...

Two options:

Run a trace on your system and try to find what is running at the same time that spotlight kicks out that error message

or

Check with SpotLight and see if...

I think I would likely go with the temp table. But I would test both first. It would depend on how you join the tables - assuming it...

Alvin Ramard (2/17/2010)

---

RBarryYoung (2/17/2010)

---

CirquedeSQLeil (2/17/2010)

---

Has anyone noticed the success/failure rate on the QOD today?

74% incorrect for Paul Randal's question on Checksum. Numbers are similar to his question the other...

What are the indexes on those two tables?

Looking at the execution plans once again, I noticed that the plan from the server does not contain an output list, nor is...