are you selecting the fine or so you need to run some job on a daily basis that will update a fine field to store the current fine for an...

Case

When col1 is not null and col2 is not null then col4=1

when col1 is not null and col2 is null then col4=2

end

Often teh difference between environments such as dev of production is simply traffic. On the test box your query likely has to contend with very few other reuests. While...

I would not say SOX itself has ever been a problem for me but the slightly twisted perception some managers had was a bigger issue. For example my last...

What I would do in that situation is create a failure path. You can add another step and when you connect it click on the connecting path arrow. ...

It should make no difference. However if that is listed as the owner of any jobs in the database they may start failing. Being the actual Database Owner...

A backup can be written to any FULL UNC Network path that you have access to.

you can also write to a network drive by mapping it if you don't want...

I am not familiar with INSERT-EXEC but thought I would point out that if you are using xp-cmdshell to connect to a non SQL server environment it is not really...

I use VB where I see you are using c# so it may be different butI I thought I would share my VB expeirence. In the control flow dts.variable...

You are correct.

There is nothing like a bulk read in SQL.

The ability to get the records out of a database as fast as possible depends intelegent design.

The database...

something else that might help is type something up about the process you implemented. Often with these types of managers having a pece of paper in their hands can...

I am not sure what you mean by as soon as possible? can you give us a scenario of what you are tying to accomplish and where the hang...

Not as famous as some of the others mentioned but since I am overly Geeky I would choose to be a technopath. I don't really care which one and they...

I have worked for someone like that a couple times.

It is not uncommon for managers to not understand and often not appreciate the technical aspects of what you...