lookup ETL ssis + upsert

select name, log_reuse_wait_desc from sys.databases

kill SPID

The lazy writer process periodically checks the available free space in the buffer cache between two checkpoints. If a dirty data page (a page read and/or modified) in the buffer...

DECLARE @filename NVARCHAR(1000);

DECLARE @bc INT;

DECLARE @ec INT;

DECLARE @bfn VARCHAR(1000);

DECLARE @efn VARCHAR(10);

-- Get the name of the current default trace

SELECT @filename = CAST(value AS NVARCHAR(1000))

FROM ::fn_trace_getinfo(DEFAULT)

WHERE traceid = 1 AND property...

declare @a bigint

set @a='100000000000017777'

select replace(cast(@a as varchar(50)),'0000000000001','')

declare @a bigint

set @a='1000000017777'

select replace(cast(@a as varchar(50)),0,'')