Viewing 12 posts - 1 through 12 (of 12 total)
It looks like I'll have to try and make my transformation scripts use SELECT...INTO more then.
Cheers guys
May 6, 2010 at 6:53 am
Cheers Paul,
The Source database is nothing to do with me either so I don't know whether Field14 could ever store over 8000 bytes. I have no control over the...
May 4, 2010 at 8:18 am
Fair doos - new here so didn't want to upset anyone on my first post!
Yep, there's 1 VARCHAR(MAX) column. Here's the table definition for the target table:
CREATE TABLE [Schema1].[TargetTable](
[Field01]...
May 4, 2010 at 7:23 am
Hi Paul,
Sorry 'bout that.
My subsequent post was (mainly) responding to your post, although I didn't quote you. My responses:
Paul White NZ (5/3/2010)
May 4, 2010 at 6:30 am
There are 11 mill rows in the Table1 with around 8 million in Tables 7 and 8. The rowcount for the result set is equal to the rowcount of...
May 4, 2010 at 5:03 am
My issue with posting the execution plan is it exposes all the values I have had to obfuscate in the statement.
May 4, 2010 at 4:27 am
Yes, there is indexing on the source tables.
I have run this through the SQL Database Engine Tuning Advisor on a few different sample databases now and have built the indexes...
May 4, 2010 at 3:59 am
Thanks guys for the replies.
There is no indexing on the target table, the table gets created just before its population.
This particular solution runs on both SQL 2005 and SQL 2008,...
May 4, 2010 at 3:38 am
I don't think tempDB is the culprit. I am sure my query is the culprit in its overuse of tempDB. I am just wanting to minimise the use...
April 30, 2010 at 5:36 am
I think I am going to have to try do the process in batches.
AS far as I am aware tempDB is used for temp tables, hash matching, group by, order...
April 29, 2010 at 9:34 am
Sorry for the confusion - when I referred to both I meant the CLR (1) and Tally table (2) approaches.
February 23, 2010 at 8:19 am
Ah, thanks guys - I have actually already used a tally table in another part of the same solution, although it was a couple of years ago, clever stuff...
I'll give...
February 23, 2010 at 12:50 am
Viewing 12 posts - 1 through 12 (of 12 total)