I agree. It makes sense to offer the columns rather than trying to guess if you're excluding them.

I've found intellisense to work pretty well so far. I'm still more in...

Late to the game...

Great comments Steve. I agree 100%. I remember a dot com emergency where I spent almost three days with little sleep and I was messing up at...

I would to research it to verify for sure, but I think you can simply point a monitor at a rule and respond to the data collected there. No extra...

Then what's on page 2?

Regardless, Page 2 needs some help.

I'd still like to see the code.

The painful plan is very large and difficult to read. The one thing that stands out is that it looks like you're performing the same joins over and over again...

Zip the file.

You might also try taking the NOT EXISTS sub-query and making it into a LEFT JOIN and looking for a NULL return. You'd need to test it, but in the...

Pages is literally the number of pages that make up the index. Smaller numbers just mean fewer pages. If your index is seriously fragmented, that number may be a lot...

You're comparing apples to oranges. Spotlight is for spot checking performance and Idera's tool is for collecting data long term AND spot checking performance. If you really want to compare...

Yes, the answer is No.

Can you post the execution plan?

And you can turn on line numbers so that they're displayed by going to "Tools," "Options," "Text Editor," "TSQL" and under the Display choice selecting "Line Numbers."

is it a multi-statement table valued function? They don't have statistics so they resolve as 1 row queries. If you're returning more than one row, then the execution plan is...

We were going to be dealing with exactly this issue. The plan was for there to be planned integration dates when all the development teams would check in their code...

There is clearly more than one way to skin a cat.