Thanks, that was my initial instinct/thought but just wanted someone to confirm it. My reasoning, which I just learned, was based on the fact that the order of the included...

Gotcha. Thanks for spelling it out for me lol. I understand your comment about not having to be concerned about alignment and performance when using SSDs to house all sys...

Good point(s). The reason I asked these questions is because I've heard people talk about having to do certain tweaks/configs when using SSDs. So are you implying I won't gain...

Do these dynamically built sql statements get stored in the execution plan? My understanding is that such statements do not, in which case optimal performance isn't attained. I guess this...

I get the intent of this question, but it boils down to semantics and how the reader subjectively interprets the question. If most people mark the wrong answer, there is...

is this job firing a SSIS package that someone built? or does this job fire off Maintenance Plan of some sort?

i'm currently studying for the MS Database Programming cert, 70-433 exam, to accomplish the same thing. The book that accompanies this exam is fairly straight forward and coincides with MS's...

i think you need a FROM clause in there because you're referencing two objects, X and Y

I want my money back :w00t:

Thanks for the feedback. No RBAR-type queries will be executed w/these iTVFs - I'm typically against such queries except for a few isolated scenarios. I may use them in a...

Agreed. Yes, I'm only using ITVFs - not MSTVFs for the same reason you mentioned.

Well, I can tell you that the select statements will:

1) be re-used several times (to process logic (i.e., w/in a sproc))

2) return NO MORE THAN one row

3) have one or...

If you have a table (let's say an Employee table) that has an index on one or more columns (let's say the Employee ID), is there any reason why you'd...