Thank you for suggestion Satya, My staging table had already appropriate indexes on it, and it turned out to be my output task for matching rows,...
I am building customer detail de-duping process in SSIS. While flowing say 2000 rows against 20 or so lookups (lookup set averaging 200000 rows) the...
Hello, As things stand, in order to get any performance out from reporting services, I must convert my database columns to nvarchar to avoid the...
Hi Satya, No we dont (or have need to) use nvarchar at all. Which specific setting should I look at? Is this set using "Reporting Services...
When I use report parameters, they get formatted with N forcing datatype transalation. e.g. select a from table where b = 'string' gets formatted...
Hi, I've got reporting requirement with need for clickthrough. I see from version features, that "infinite clickthourgh" is only availabe with the...
I am using a instead of trigger in the first place is because I am "updating" a unioned view. The reason why I am using a derived column is because...
Hi all, I am having big performance problems with scenario where I hope to capture values from inserted. Update query contains where clause id =...
Hi, There are no other users using the database as this is being run on a specially setup test db. And can be repeatable any time I like.
Hi all, Following statement performs very differently with an without (nolock) hint. Can someone explain why the difference is so huge, or if I can...
Thanks biged123456, Will try out this tool I was previously unaware of. Aku
Hi all, Has anyone got any experience on upgrading to 2005 yet? We recently upgraded our systems from 7 to 2000. Now there seems to be scope for...
Thanks for that tip about table variables mmarovic, will try that. In fact by dropping all temp tables as they become not necessary seems to...
OK, it gets a little complicated here.. but please stay with me Result after leaving the job as was in SQL7 "SELECT MAX(SeqNum) FROM #a" Takes 15...
Full build info: Microsoft SQL Server 2000 - 8.00.837 (Intel X86) Jun 23 2003 14:50:30 Copyright (c) 1988-2003 Microsoft Corporation Standard...
Frank - I meant to say sql7 to sql2k upgrade (sloppy typing, sorry) Build is win2000 + sql2000 sp3 + hotfix for correlated subqueries. More...
No index (will try), but even without index this should not be taking 14 seconds, should it !? Table only has got just over 100 rows in it.
Hi, We have a SQL 2000 batch process using temp tables. Table #a has 116 rows of 15 (narrow) columns (SeqNum is identity column) "SELECT...
If you need quick fix try separating the or statements with unioning the whole query. Result is ugly and replicated code but will buy you time to...
Sure looks like generated code to me... Unless you can attac the way code itself is generated, first try to get rid of hash matches by indexing...
Separate names with a comma.
