ChrisM@Work (6/9/2014)

---

BWFC (6/9/2014)

---

ChrisM@Work (6/9/2014)

---

BWFC (6/9/2014)

---

ChrisM@Work (6/9/2014)

---

BWFC (6/9/2014)

---

ChrisM@Work (6/9/2014)

---

Is there any chance that your original query - the one with the error - had a filter for the comma in the...

Sure, here's what the restore software issued:

3556 2334 06/12 20:39:20 323781 CCvSQLVDIBase::StartDBRestore() - !!!!QUERY:...

Beatrix Kiddo (6/13/2014)

---

When you say files, do you mean you were restoring a backup in the usual way,...

Matt Miller (#4) (6/6/2014)

---

Sometimes a little test helps to clear things up. The indexing does seem to help, so the trade-off is whether the improvement is enough to offset...

This query isn't actually returning any data to a user; it's part of an archival process and a @BatchID gets specified rather than a range to query. Batches can range...

Sean Lange (6/6/2014)

---

sqldriver (6/6/2014)

---

sql-lover (6/6/2014)

---

The one that your supervisor does on you every year? To check if you are doing "Index Seeks" or just "scans"...

sql-lover (6/6/2014)

---

sqldriver (6/6/2014)

---

sql-lover (6/6/2014)

---

It is my understanding that an aggregate function has to check all values in the column. So an Index on that attribute may not help too much.

Now,...

sqldriver (6/6/2014)

---

sql-lover (6/6/2014)

---

It is my understanding that an aggregate function has to check all values in the column. So an Index on that attribute may not help too much.

Now, not...

sql-lover (6/6/2014)

---

It is my understanding that an aggregate function has to check all values in the column. So an Index on that attribute may not help too much.

Now, not sure...

sql-lover (6/6/2014)

---

The one that your supervisor does on you every year? To check if you are doing "Index Seeks" or just "scans" at your job?...

GilaMonster (6/6/2014)

---

pietlinden (6/5/2014)

---

If you dig around here even a little, you'll find Gail Shaw's explanation of what NOLOCK really does. You might need to make them read the article...

I've been working pretty hard to first bring all the server settings in line with best practices and then dig in to the queries. I've been using a lot of...

So then what are plausible alternatives? What can I present as a change to say "you no longer have to risk incorrect results by using NOLOCK because A is alleviating...

hisakimatama (6/5/2014)

---

Yep, I've had that problem. Found NOLOCK all over the coding in the vendor-provided software at my current workplace my second day there, and reported it to my...

pietlinden (6/5/2014)

---

Not sure what to say. If you dig around here even a little, you'll find Gail Shaw's explanation of what NOLOCK really does. You might need to...