just on the table, you dont need to run it on the whole database

Example that proves the reindex theory

use beta

go

create table JM

(

colA int identity(1,1) primary key,

col2 varchar(20),

col3 int

)

go

declare @count smallint

set @count = 1

while @count < 1000

begin

insert into JM (col2, col3)

select 'Number ' +...

if you rename the table and then rename it back does the space change?

The above is the best thing to check first.

Another thing you can...

I remember reading on here some months back about how sql still holds the space for the data with the old type AND the new data type hence why the...

you could try and kill it but its likely it will take around 15 mins to rollback.

try doing the inserts in batches

By definition you cant. No amount of convert/case/coalesce will ever get this work.

Mad-Dog (2/1/2010)

---

i know that i...

is the field your updating an int field? if so you wont be able to put 'No data' into it. Post the create table scripts for both your...

update <tableA>

set <column> = case when B.<column> is null then 'No Data'...

use a case statement as well as the cast/convert.

case when <column> is null then 'No data' else cast(<column> as varchar(x)) End

ah ok, from your origional post it seemed like it was always model that was causing the issue. So now we know its not database specific is there anything...

I get the problem quite often (once a week) always in the morning (UK time). My links send me straight to the forums and this just times out, so...

why not as a temporary measure remove the model database from your litespeed backup job and give it its own job. that way at least if it fails its...

data changes or schema changes?

Positive (12/28/2009)

---

Thank you.

Just as a FYI, I was wondering if there are any workarounds to not stop and start SQL Agent in case of password change. In other words, what...