Have you tried with '1' instead of 1?

Also check the execution plan for implicit_conversion which would confirm vladan's theory.

And run the job every 2 minutes at least so that at most there is a 6m59s delay before the queuing and execution.

Dev server??

DBCC FREEPROCCACHE

Now you can search these forums for parameter sniffing to get more info on that topic.

I wouldn't expect any problems with that approach (without fully knowing your system).

Now to conclude... You only backup daily (I do too but with trans backups every 30 minutes >> we...

I don't see why this would be a problem (aside from creating a bug in the web application).

The real problem here is why do you backup only once a month?!?!?!

Can...

Sorry but I don't know the answer to that one... I guess we'll know at the same time.

But if I were you I'd keep reading those articles... they'll come in...

NOT NULLS means that the column is not nullable.  If there already is data in the table and you need to add a non nullable column, then you have to...

ALTER TABLE dbo.TableName

ADD ColName INT NOT NULL /*optional from here*/ CONSTRAINT DF_TableName_Init DEFAULT (0)

You got a little bit of reading ahead but it's really worth it, for everyone involved.

http://www.aspfaq.com/etiquette.asp?id=5006

http://www.sqlservercentral.com/columnists/siyer/2645.asp

We can't answer this type of question without having the tables ddl (with indexes and keys) along with the query and execution plan.  ONce you provide that we'll most likely...

Add an sql step at the end of the first job and type in this line :

exec msdb.sp_start_job @job_name = 'jobname'

That will start the 2nd job.

Now that would be an interesting test...  Count the recompiles of each execution plans.

Anyone got time to set this one up?

I'm with Vladan on this one.  This topic has spawned a few 100 articles on the web because the topic is so large.  Here are 2 articles that will get...

IIRC I had tested them in both orders.  Do you have different results to show us?

You can always set a goal to build something challenging, then write an article about it!

Off course the money is not as great .