This means that you have a bad plan in the cache. The bad plan could come from stale statistics at the moment the plan was calculated.

Try updating stats and issue...

I think that *real* replication (transactional IMHO) would suit better here.

Is this one way or you need data to be replicated bidirectionally?

Paul White blogged about simulating sequences in SQL Server here.

It can't be done exactly that way. A DML statement is executed completely or not executed at all.

However, you could check the values in advance and import valid rows only.

GilaMonster (2/15/2012)

---

Gianluca Sartori (2/15/2012)

---

According to MSDN, the NULL bitmap size is calculated as:

Null_Bitmap = 2 + ((Num_Cols + 7) / 8)

This suggests it could change. I've never seen this happening...

paul.knibbs (2/15/2012)

---

Is it possible it would have to expand the size of the NULL bitmap to accommodate the extra column, or is that...

No need to write C# code.

A simple UPDATE will be enough:

DECLARE @sampleData TABLE (

telephone varchar(20)

)

INSERT INTO @sampleData VALUES('9217335621')

INSERT INTO @sampleData VALUES('9217854234')

INSERT INTO @sampleData VALUES('9217115526')

INSERT INTO @sampleData VALUES('9217418795')

INSERT INTO @sampleData VALUES('9217417896')

UPDATE...

You're welcome.

Glad I could help.

chandrika.r 91171 (2/14/2012) via Private Message

---

Thats fine but still did not get the solution Gainluca. lets say I have some 100 jobs scheduled at the same time. one table is...

You're welcome.

Glad I could help.

1. Download sp_WhoIasActive

2. Run the script to create the stored procedure

3. Start the SSIS package via job

4. Open a new query editor window in SSMS and type:

EXEC sp_WhoIsActive @get_outer_command =...

I mean that you could...

You could:

1) Start the browser from the command line and capture the output. Maybe there's something useful in there.

2) Trace the process with Sysinternals' Process Monitor and see if there's...

This is one of the dumbest questions I have ever...

You could quey locks being held on the table in sys.dm_tran_locks.

I would not re-invent the wheel, however, I would rather pick a ready-made tool like Adam Machanic sp_WhoIsActive.

With that procedure,...