Hi Jeff,

Great article, and yes I can see how running it against a large dataset could take some time. In my scenario though we're just doing a few hundred...

SSChasing Mays, that's exactly what I was looking for. Thanks... I didn't think to use Distinct.

SSCrazy, sorry for not following etiquette. I thought I covered all...

Hi GSquared and Paul,

Thanks again for the great info, and it does sound like it's a blunder in how SQL is defining the execution plan. I could continue pursuing...

Hi,

Actually it seems rebuilding the execution plan fixes the problem, so I'm now trying to find out what's causing the problem to begin with because as of today it's doing...

Sorry for the delayed reply...

Lowell - I'm checking out your stored procedures now and I think those might just do the trick. Thanks!

465789psw - The problem is the server...

GSquared (10/14/2009)

---

Overwriting it probably just forced a rebuild on the execution plan. That's probably the only difference. I'd have to see the function and any related tables to...

Jack Corbett: SSRS stores the names of the columns as part of the report definition (rdl file), that's the only way it can know what to display where in the...

Hi Everyone,

I found a 'solution' that works, but it's crummy I have to do this. I ended up bundling my SQL statements in to a variable and executing those...

Resolved....

I found out what was happening... We keep all our Configuration files on the server, and this package was set to use a Configuration file which was overwriting what I...

Hi,

Quick update... I just noticed this is also happening on ADO.NET:SQL Connections as well as OLEDB connections. I can edit the connection, save it, but whether I run it...

Joe,

I had a similar problem with importing in dBase files into MS SQL through SSIS, and my work around was to create an Access Database with Linked Tables linked to...

Hi Everyone,

I didn't post the entire process because our eventual goal is to return a list of all Customer information from the Customer table and various other tables which is...

I wrote a work around that creates a Temp table based on the table schema which I hate to do, but it works. It will need to be called...

:angry: Hrm, it looks like doing it this way excludes all Identity fields, which won't work. Does anyone know the technical reason why this would be so? I...

Hi Fraggle (love the nick!),

I was able to get the Select using OPENXML to work with a table name as opposed to a hard coded definition. This works in...