Thanks for the ¿

Hokey

Woot.

I probably am in the...

The problem you are experiencing is related to the temp tables and the pre-validate. I would dump this data into a persisted table if this is something you are...

I'm thinking...

Slow day (on the thread) so I figured I would share here:

http://bit.ly/sFJoy1

I think the issue as you described is going to be somewhere between video memory and the memory defragger. The CleanMem has worked well for me with BIDS doing...

Wow, I really think the best solution is to get help from the teradata team to help create this query on their end. Alternatively, you could try chunking the...

Can you elaborate a bit further please?

The only other thing is to try and break up the query. Sometimes you can break the query out to pull from a subset of tables and then do...

What is the max memory for SQL server on this box? How much video memory?

Have you looked into a memory defragger/cleaner such as CleanMem?

If you already have the groups or accounts created in AD, then you need only add that user to the instance through ssms. Create a login that maps to...

Create a stored procedure and then execute the stored procedure from there.

Yes. You can also have an active directory group added to the sa server role if you would like. That is a common practice and is better (imho)...