Hi Wayne,

Nice one, have you looked at the performance of using the XML joins in your stored procedure?

I did quite a bit of performance testing with the "other" methods...

Hi Philippe,

Thanks for the post. This was the one option we considered but did not test as we were running on a SQL2000 database and I had never worked with...

Hi sebastian,

I don't normally use indexes on temp tables as building the index is often more costly than not using it. In this case we did test it with, and...

Hi dph,

Have you done performance testing on this with large tables? I try to avoid "LIKE" statements as much as possible as they have a tendancy to cause table scans....

Hi Jim,

Your approach is the same as what we did, and found it to be highly inefficient, have you done some perfonace testing on big tables and wide range of...

Hi Jon,

Interesting idea. Have you tested this against large tables? This would result in a table scan which might have a big impact on performance...

Hi SDM,

It could well be that my results were affected by our table size and parameter length as it was a fairly large table and many parameter options (strings) selected....

Hi Jose,

We tried to split the string into records, and insert it into a temp table yes, and it had some perfomance boost but the cost of splitting the string...

Hi Joao,

Can you please give the Port Number for MSDTC

Hi,

Are you doing this for an RS report? I have submitted an article to this web site about working with Multi-Select parameters in RS, but it is not published yet.

If...

Go: Start >> Run >> Services.msc

Then look for a service that starts with SQL Server Analysis Services, behind it it will say the name of the instance in brackets, on...

Hi Grasshopper,

I'm not shure how hardcoding the UserName and Password in the DataSource tab would improve the security, please explain.

If you have a large number of reports, and the username...

Hi Grasshopper,

Thanks for the reply. The reason why I don't use Custom Datasources is because of the security configuration required. We use shared datasources executing on a specific SQL login....

I got real excited when I saw the article as this is something we need, but it is unfortunate that you cannot use it with shared datasources... We only work...