Test the execution plans but my testing shows this form of the query perform a bit better than the DELETE...IN method:

-- Credit to Itzik for exposure to technique

WITH ...

Some random thoughts...

1. MSIS = Microsoft Integration Services? Maybe a local Windows account or Domain account accessing the server via an AD group?

2. Re: the logging table you have setup...do...

steve smith-401573 (4/8/2011)

---

I apologize for the confusion. Let's try this: SS 2008 SE database TABLE aggregates system logs from multiple servers for multiple 'customers'. The requirement is...

BCP would be an excellent solution IF I knew the output file format. Where will I find the definition(s) for truncation that SSMS provides? When I examine an...

ISNUMERIC was not changed from 2000 to 2005 with respect to a single decimal point. This returns 1 on 2000 and 2005:

SELECT ISNUMERIC('.') ;

which happens in support of the...

Keep going...your query is subject to a data-driven bug.

CREATE TABLE #temptable(tranName varchar(1),planname varchar(20), priority int)

INSERT INTO #temptable VALUES ('a','plan1',1)

INSERT INTO #temptable VALUES ('a','plan2',2)

INSERT INTO #temptable VALUES ('c','plan3',3)

INSERT INTO #temptable VALUES...

It has to do with the optimizer and how much "smarter" it has gotten since 2000. In your situation however you are experiencing a regression as a result of improvements...

Dominic Gagné (4/8/2011)

---

Hi,

I need to extract data from a linked server by using a StoredProc with a parameter. I wanted to store the result in a temporary table...

Here is a good start explaining how NULLs are tracked by the storage engine at the page level in non-sparse columns: http://www.sqlskills.com/BLOGS/PAUL/post/Misconceptions-around-null-bitmap-size.aspx

And some info about Sparse Columns: http://www.sqlskills.com/BLOGS/PAUL/category/Sparse-Columns.aspx

I do not know what the proc is doing so I may be completely off the grid here...but I can't get over the assumption that you should even be in...

I agree with Dan. I categorize this kind of work into the sysadmin domain which is not a strength of SSIS.

What you've described is a need to sync a...

BCP is a good candidate for this kind of work. It can...

bozzybox (4/7/2011)

---

Thanks for all the replies. Looks like what I am trying to do is not do-able in SQL Server.

As requested by Mr or Mrs. 500, here is an overview...

That's good info, thanks for your responses.

Do you have any experience using the technique? Can you speak to how well it scales?