Ed Wagner (9/1/2015)

---

That's a neat approach and...

Maybe

Depends if the index is useful to the query and the query capable of using the index.

Not knowing how you're replicating the data, it's a little hard to suggest alternatives...

The problem is likely to be the Group By that you have there. I don't know why it's there, because there's no aggregations.

If the group by is removed, and someone...

There's probably either no suitable index, or the update is written in such a way that SQL can't use the index and has to scan the table, hence the table...

Please start a new thread and give us as much information as possible.

It's normal for sessions in parallel to 'block' each other. Your wait times are all around 15-30 ms. Why is this a problem?

Before you implement that, please read this: http://sqlinthewild.co.za/index.php/2009/09/15/multiple-execution-paths/

For what?

And do you need symmetric encryption or asymmetric?

How many physical cores per processor? Don't look at SQL, check the specs of the processor you have.

Thanks everyone

I'm leaning towards getting a 256 GB SSD for the OS and then 2 (or 3) 1TB drives for all the large stuff (databases, graphics resources for my 3D...

What exactly do you mean by 'configuring virtual memory'?

You'll need to import the spreadsheet into a table first. Use the Import/Export wizard for that. Once you've got the data in a table, use the UPDATE that Jason mentioned.

A question for those who have upgraded to Windows 10 and have SQL and Visual Studio installed:

What the total size of the Windows and 2 Program Files directories?

I'm trying to...

My Win 7 machine's got to the point of bluescreening about once ever 2 days with a System Service Exception (or something like that), so it's going to have to...

Grant Fritchey (8/31/2015)

---

briankwartler (8/31/2015)

---

Grant, Jeff, and Wayne:

Which ORMs do you have experience with? I would think that the designers of these ORMs would very much like to hear of your...