What does "Creating an index within the application" even mean?

Speaking of... If you tried running a query against a table (a simple select) and if never returned, what would you...

alex_pixley (8/7/2014)

---

Yes, adding disk space is easy. In some environments, however, getting additional disk space approved and implemented is a painful process. Right now, I have 13 partitions...

And fragmentation...

Maxer (8/7/2014)

---

I was wondering about odd scenarios with dirty read for that select or if it could ever fail to read 100% of the rows up front so it attempts...

You may have missed the word before that phrase.

"The average of those isn't 'definitely not'"

Then start by removing nolock, as it causes exactly this (duplicated rows). Same with read uncommitted isolation level.

Is it repeatable

Are they connecting to the same instance, same database

Are they using nolock/read uncommitted?

Yes

2. Would it ever NOT do that? Would you ever get a batch scenario where you read maybe...

Can you post the definition of the procedure SCHOrdersSave_v3?

Also, where's the rest of the deadlock graph? The resources section is missing, please post that.

jonidotcodotuk (8/7/2014)

---

Jeff Moden (8/6/2014)

---

Ed Wagner (8/6/2014)

---

How about a very simple one?

Please write the T-SQL code to count from 1 to 10.

There are many correct answers and how they answer can...

An empty partition is not going to be taking up any space.

Or do you mean swap out and merge old partitions as time goes on? If so, that's just...

Not on the system tables. On the table itself. Dropping, altering, creating...

Your query is blocked. Check and see what is blocking you.

Luis Cazares (8/6/2014)

---

Eirikur Eiriksson (8/6/2014)

---

benjamin.reyes (8/6/2014)

---

Eirikur Eiriksson (8/5/2014)

---

Grant Fritchey (8/5/2014)

---

Eirikur Eiriksson (8/5/2014)

---

Guess one has to differentiate between five years of work and five years worth of experience. Questions like "what...