Thanks for the reply.  I was hoping that the SQL Server community would provide a little more thought around LINQ.  I know its new, but I believe there are enough...

Not sure if you got this working, but make sure that parameters do in fact have data coming through.  Also, check the reportserver and make sure that the parameters are...

try this,

Since I don't know your network and am not familiar with your set up, you can always try and use a SQL Server User in the datasource for the...

would xp_execresultset work?  Undocumented and Risky, but available.

I understand these tests that we are performing, and I agree that it is good to do these.  But I am still having a hard time understanding the basics of...

Thanks Carl, good work.  Anyone who has been performance tuning with SQL Server and has worked with Scalar UDFs would reckognize the performance hit.  It is amazing how harmful they...

Jeff,

How can you disprove that UDFs are NOT harmful?  Let me see.  If the cost of a query exceeds to high and parallelism is used, a Scalar UDF will...

My two cents:

Over the years working with UDFs, I have found that they have a place and time.  I have rewritten code in a SELECT statement to NOT use UDFs...

Mark,

When using Replication, can any column be the Clustered Index, or does it need to be the Primary Key or a Unique column?  I was told that the Clustered Index...

I rather enjoyed the article.  Sean, your pieces here are worth reading.  These circle jerks can't get there head out of there b**t long enough to see that your opinions...

Paraphrasing...  Got it from DataModel.org.

The union was used somewhat loosely.  If you have CODE_A from table A and CODE_B from table B, and union the codes together, you would have...

I couldn't have stated it any better.  Thanks DC

This discussion doesn't seem two sided.  We are all saying the same thing and 90% percent of us agree that MUCK and...

Again, you are enforcing RI by code, instead of enforcing RI by true Referential Integrity.  Yes, it has conceptual merit, but if you want to achieve quick performance on your writes...

I have worked with Generic Lookup tables in the past.  It was not my design, and did I voice my concern to management; of course I did.

The concept of one...