Are your schedules enabled ?

What kind of jobs do you have ?

- local sqlinstance only

- ssis packages

- cmdshell

did you change the sqlagent service account lately ? (and does that...

Do you need info of some ids or of all ids ?

If all, just remove it from the where clause.

If some: can you predefine them ?

Avoid loops, think sets...

I would prefer an inner join, but you'll have to figure out what kind of result set you actually need to determine if you need a left join.

Off course, if...

- you also need to take care of the inner join that you use in combination with a left joined object !!

- for the moment you are using...

If you need the three conditions to be true, why are you coding left joins in stead of inner joins ??

If you only need to validate B and C if...

avoid dynamic sql if you can ....

all time ref: The curse and blessings of dynamic SQL http://www.sommarskog.se/dynamic_sql.html

But I don't think you need dynamic sql anyway.

So, skip the "declare...

as you have seen indexdefrag may not give you the results you aimed for.

(Books online has more details about the differences between dbreindex and indexdefrag)

Do you have a clustered index...

Maybe it wouldn't be such a bad idea to contact SQLCAT to get your calculations confirmed that would make mirroring the optimal solution for your case.

Another ref that may help...

have a look at: "A SQL Server DBA myth a day: (12/30) tempdb should always have one data file per processor core"http://www.sqlskills.com/BLOGS/PAUL/post/A-SQL-Server-DBA-myth-a-day-(1230)-tempdb-should-always-have-one-data-file-per-processor-core.aspx

sudhakara (4/22/2010)

Can you share me the link where i can learn...

As already stated above : probably these parameters haven't been provided by the connection.

Some applications use a config or ini file which provide the connection string.

e.g.

add key="SQLServerConnectionString" value="Data Source=TheDevServer\Instance01;Initial Catalog=MyDatabase;Integrated...

You should contact your mail server admin and ask him/her to allow smtp relay for you sqlservers IP adress.

Did you have a look at ongoing process locks during your jobs ?

Maybe your website is just being forced out because of the locks your sql jobs cause on your...

Paul White NZ (4/20/2010)

Not for enforcement purposes, no - you need an unfiltered UNIQUE index/constraint or a PRIMARY KEY....

Can you use that kind of filtered index for DRI purposes ?