You've never used Performance Monitor before?

That is about the best index. I'd put ID as an include, as it's a bit wasted in the key.

An index seek operation requires a filter predicate. None of your...

You'll probably find that the senior guru expert development lead decided...

CROSS APPLY?

I'd be seriously considering throwing out such a restrictive framework tbh.

Did you install it? Depending on what options you selected, the client tools may not have been selected by default in the installer.

Grant Fritchey (12/27/2014)

---

Lynn Pettis (12/23/2014)

---

Okay, I have a question about PASS 2015. I can save a lot of money by registering for PASS 2015 now. My question is...

If by 'solved' you mean 'changed the meaning of the query and possibly the results', then sure.

I can't understand though why you've...

Praxo (12/27/2014)

---

Limitation I was referring is from front end side, which as I mentioned generates the SQL dynamically. The front end is not having this framework and does not support...

Why can't you use UNION ALL? It would be the obvious way. There's alternatives, but they're complex

A full set would be preferable, but since that's several steps (and probably weeks of work) away, it can be discussed and debated while getting the needed baselines.

As one would generally like to see.

What issue?

The...

No you can't.

Oh, you can put the hint there, but SQL ignores it. Updates are always, without exception, done with exclusive...

Shafat Husain (12/26/2014)

---

Another way to go about it is that you can change the recovery model of the database from Full to Bulk logged and hence Alter Index statement would...

It is, for TempDB and only for TempDB. It is not,...

Um...

From the very page you linked:

Bulk import operations (bcp,...