It goes back to the histogram on the statistics. That is only build on the first column in the index key. The others are used to help establish the density...

Query performance measures alone won't show you what is blocking or being blocked. Since you're on 2012 you can use the blocked_process_report extended event. That will tell you what is...

Best thing to do is get that thing local. Any cross network process you go through is going to be extremely painful.

You measure the speed at which queries that access that index are performing before and after you defragment the indexes.

patrickmcginnis59 10839 (4/3/2014)

---

Grant Fritchey (4/3/2014)

---

It's an approach taken by a developer or development team that doesn't understand SQL Server, or, just didn't want to take the time to do things...

Cody K (4/3/2014)

---

Just to play the devil's avocado:

- XML is a first-class citizen in SQL Server and as far as validation goes that's what DTDs are for. Right?

- I'm not...

Not a problem. Happy to pitch in.

It's an approach taken by a developer or development team that doesn't understand SQL Server, or, just didn't want to take the time to do things correctly. It's very fast...

Hard to tell for sure what's going on without seeing the execution plan. Chk001 sounds like a column derived somewhere else within the plan. A key lookup suggests that you...

Probably not. You'll note that the leading edge of the key, the first column, is different between the two indexes. That's one of the bigger driving factors for index selection...

It wouldn't "elect" to. Some script at some point had to declare that it should.

Just remember, SQL Server will always use every bit of memory that let it have. It's very normal and by design to see all the memory in use. You've done...

You can use a unique index as a foreign key too. It doesn't have to only be the primary key.

SQL Guy 1 (4/2/2014)

---

Grant Fritchey (4/2/2014)

---

There's a lot to it. I wrote a book on the topic (look in the links below). But, to get you started, I'd recommend...

That is not a measure of which plan is better. Those are estimated values only and do not reflect any...