Peter Samson (2/4/2010)

---

Grant is correct, but the command you need to use is DBCC FREEPROCCACHE. The command mentioned by the previous poster will actually drop the cached data pages.

Please...

This is a known problem with the SCD transform.

Your alternatives are:

- use the Kimball Method SSIS Slowly Changing Dimension Component[/url]

- instead of doing the updates via OLE DB CMD, use...

Grant is right.

If you want to test the impact of the caching, use

dbcc dropcleanbuffers

before running the SP (but after it has been compiled 🙂

and then immediately run it a second...

There's probably some caveats to this approach, but you can try this for starters:

SELECT OBJECT_SCHEMA_NAME(id)

,OBJECT_NAME(id)

FROM SYS.SYSINDEXES WITH (NOLOCK)

WHERE ...

Try to drop the indexes that are not used for the delete, do the delete and then rebuild the indexes.

Richard,

I'm Belgian too 😉 but as you know that is still no guarantee for easy communication 😀

If you use Google, you'll find lots of information on the double hop issue,...

I'm not really into HTML so there may be something wrong with the formatting, but this should be enough to get you there (I developed the sample on the AdventureWorks2008...

The changes from 2005 to 2008 are less intrusive than from 2000 to 2005. So I don't think this will be a problem although there's a minor risk that you...

Have not encountered that one yet, but there is always Google: check this article.

Try running the report in BIDS. Normally you will get a more descriptive error. Post that and hopefully we will be able to help you further.

You could use a trigger, but this also works:

CREATE TABLE [dbo].[mytable] (

[col1] [int] IDENTITY(1, 1)

...

The first time, your SP needs to be compiled. This could explain the difference in 'apparent' execution time.

Try

sp_recompile 'name of your procedure'

If you now execute your procedure again, you...

Here's what I would do:

- consider adding the missing index that the sqlplan mentions

- use a temp table #timesheets rather than a table variable @timesheets to see whether that makes...

Ricky,

Based on the desciption of your requirements, I would like to share something I have done before in SSIS - maybe it is useful in your situation too.

In the Data...

Maybe I was a bit cryptic in my previous post, but this article[/url] (never tried it) seems to suggest that it is possible. Look at the last code block.