How many rows is your query trying to delete? What else is happening on that table while you are running your delete? Are you running the delete in a transaction...

It sounds like you did not do all the steps or you may not have a current enough build. What does this return on your system:

SELECT SERVERPROPERTY('Edition') AS Edition,

...

If all you are looking for are insert statements generated from an existing table then I would recommend the SSMS Tools Pack:

Generate Insert statements from resultsets, tables or databases

Insert statements...

It will depend on the destinations. If all destinations...

Yes. Look into using the Data Conversion transformation...

What I see a lot of people chasing when thinking about implementing partitioning is 'partition parallelism'. The idea that if a query asks for data from multiple partitions were parallelized...

So would you say this is simply one area where the concept does not transfer from Oracle to SQL Server? Oracle touts partitioning as a way to improve performance by...

GilaMonster (5/19/2012)

---

You are highly unlikely to achieve anything other than adding complexity and wasting time. Partitioning is not a performance optimisation (mostly), it's for ease of maintenance, loading and deleting...

Uripedes Pants (5/17/2012)

---

opc.three -

you've helped me before and I really appreciate you and all the good folks on this forum. sorry it took so long for me...

Jeff, your comments helped settle me down. It's nice to have a timeline now on when I might see the article accepted and potentially published. Thanks as always for all...

I do not. I have not received any feedback since submitting the article earlier this week. This being my...

Well, I was going to do three that build on one another so it would be...

I got...

Well I can confirm the issue in BIDS 2008 (IS v10.50.2806.0). I looked at your test file and the BOM and EOLs are correct. I also checked the small e...

EXEC sys.sp_helptext

@objname = N'dbo.sp_help';