I can't know that it'll solve the problem since we're not sure where the contention is coming from. However, I can say with some assurance, it's definitely going to somewhat...

Yeah, and no way to...

It suggests an I/O issue. A couple of things could be causing that. First, have you looked at the execution plans when the query is doing more I/O? If they're...

I have an explanation from Paul White, so I put a lot of faith in it.

It was my understanding that when a plan was found that was adequate according to...

GilaMonster (8/26/2015)

---

I do. All my colleagues and clients, whose machines I end up working on from time to time while helping/consulting, not so much.

And you've changed snippets. de <space> gets...

Ed Wagner (8/26/2015)

---

Hugo Kornelis (8/26/2015)

---

GilaMonster (8/26/2015)

---

In that case, mine would be SEELCT left left backspace left L...

Ah... well, then other stuff may have been run. It's hard to say without knowing more. I ran this test:

USE TestDB;

GO

CREATE SEQUENCE dbo.MySequence

START...

I don't know why that property is sometimes missing from a plan. I'll see if I can find out.

How are you capturing this query? Through SSMS? Querying the cache? Capturing...

Another vote for No.

It's a fight you're likely to lose unless you can provide alternatives. I'd suggest looking at log shipping to another server. If you can, get upgraded to...

Can you post one or two samples of the plans that don't have that property?

I don't see any indications in the documentation that the ALTER DATABASE command would reset sequences. What process or syntax did you use to rename the database?

sgmunson (8/25/2015)

---

Jeff Moden (8/25/2015)

---

sgmunson (8/25/2015)

---

Rod at work (8/24/2015)

---

Hmmm. Thank you Grant, I really appreciate the straight forward explanation for what the rowversion/timestamp is all about. I'm working on archiving the...

If it ignored the index, it's because it wasn't satisfying the queries. Columnstore indexes work best with aggregate style queries. They don't work at all well with point lookup or...

Part of the DBCC process creates a snapshot of the database. That snapshot was marked corrupted due to an I/O issue (undetermined from here). So your main database is fine.

However,...

I'm with Sean. It sure sounds like normalization might be an issue. I'd focus there as well.

In terms of impact of adding a column, it depends. If you're talking about...