is this as simple as an update?

update yourTable

set yourCol = Null

or am i missing something?

are you pointing to the same server/database in BIDS as in the Job ?

because it looks from the error message that a table can't be found.

you could use BitLocker if you have Windows 7 (server 2008) and above.

I usually just compress them with a password though.

It a standard way of loading a data warehouse.

you first need to have something on the source table to let you know when a record has been inserted/modified. Usually this...

Sounds very annoying..

As for telling the real vs fake nulls apart. The 'Real' null values should have a slight yellowish background to the gird cell when viewing the results...

I was just offering another suggestion, I am aware of the power of the tally table split. As SSIS can deal with individual rows quite effiecntly i am...

you can use SSIS for this.

Set up a connection to the source and if this is a flat file then you can change the delimitter on the source to a...

The poll does seem a bit skewed towards the positive,

because the only answer if you 'do not cringe' is to pick 'whats wrong with it'

where people's...

I agree, you should not have to drop the FK constraints as you want to maintain the integrity. And I am not sure the performance gain would...

Select customerID,FirstName +'_'+ lastname as customerName from tblemployee

order by FirstName +'_'+ lastname desc

Just curious, do you live/work in a Major city in the US?

I understand...

That syntax looks okay, what were the errors that you were getting?

I guess the problem is that certain users are running large inefficent queries that take a lot of cpu and time to complete, is this correct?

The issue you will have...

you can filter on loginname to exclude those ones you dont want.

Though i have to say writing this kind of function into your server could cause issues, and I...

you can then use

sys.sysprocesses

to get the SPID of the connection and then pass this to the KILL function.