. . .

SELECT u.Alias, du.FreshPointsBalance, COALESCE(cte.PercentPoints,0) AS PercentPoints

. . .

About a year ago, an interviewer pressed me on esotheric points of high-performance C#. Could I make Replace() faster? How would I go about it? Would endian encoding slow...

I am joining this discussion a bit late but please let me put my two cents in.

In my experience, the problem is not that SQL is an inadequate tool for...

Steve Jones - SSC Editor (3/21/2011)

---

Revenant (3/21/2011)

---

For a fine-tuned, high-performance system I would recommend a complete performance review after each service pack. It is time-consuming and therefore expensive, but...

You do not DISCOVER an SQLS Service Broker -- you just ACTIVATE it:

http://msdn.microsoft.com/en-us/library/ms171617.aspx

Robert, are you asking about SQLS Service Broker, or another another broker (with lowercase 'b')?

For a fine-tuned, high-performance system I would recommend a complete performance review after each service pack. It is time-consuming and therefore expensive, but it it prevents unpleasant surprises.

I would accept a teaching position. That's something I am looking forward to when I (sort of) retire. If I had total financial freedom, I could do it now.

You may try something like this:

// Get the report execution service.

ReportExecution2005.ReportExecutionService res;

try

{

res = new ReportExecution2005.ReportExecutionService()

{

...

As we are one of several IT groups, we tend to think about "our users." We have to keep our users happy even when we think that things they...

#Columns is what I meant by "dictionary of columns". I csan only guess but I think that there will be some parsing involved.

That's all Chinese to me. <g>

You do nolt have to load each column into a different table; however, if you are loading columns into more than one table (which is likely the case), you would...

I am afraid you will have to live with your circumvention. If this happened under Win7, I could report it as a (difficult to recreate) bug. Unfortunately, bug reports for...

Yes, that would be a data flow. However, you need one dataflow per target table, and for 200+ that would be difficult (although not impossible) to maintain.