I would like to extend what Goce has pointed out as 3 rd point.

First of all Split query in 2 part (Your select part and the From part for which you...

It should not have any impact on the indexes that are already built. Every index will be built as transaction, to my understanding the last one which is in process...

John,

Here is what you need to do

enter and run the following Transact-SQL commands:

 SET STATISTICS TIME ON

and  below that place your...

In EM go to your Job

Right Click- select-- Properties--Select Schedule and click delete button

on the bottom.

Then whenever next time you want to run manually execute that job.

Dipen,

After reading your post, what I would like to suggest you is this.

In your case better stay with full recovery model. Reason for that is with every day full backup...

I think probably you have statistics for same column and wizard makes safer suggestion  with interpretation that in absence of stat this index can be useful.

Jol,

The logic here is you need to do something for

server to identify row in unique way

try left outer join with combination of 2 col.

In your case Account# looks unique

Something of this...

Jol,

Please do not post same question at multiple places.

Your question is answered in administration

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=271655#bm271701

The error is in your table a

where you are using usr jo for both row.

This is very bad practise for join.

Join need unique identification of row.

For your expected...

Thank you Antares, I agree with what you are suggesting.

But say for example, I would like to add one more situation,

say if application server is recently reboot by developer and...

Hi,

Today I have provided my detail resume thru email at hr@visionamics.com

Thanks,

Create a batch file called RestartAgent.BAT with the following commands in it, and save it on the C:\ drive:

@ECHO OFF

NET START SQLSERVERAGENT

While running the above command, make...

Execute following command in Query Analyzer

SELECT sj.job_id,sj.name,step_id,step_name,

CASE WHEN run_status = 1 THEN 'Success'

        ELSE 'Failed'

        END AS Status  ,

CAST ( LEFT(CAST(run_date AS VARCHAR(8)),4) + '/' +       SUBSTRING(CAST(run_date AS VARCHAR(8)),...

There cannot be simple one command solution for this.

There are few places  you should look for at first 

1. Check error log to figure out what was going on Db...

Satyam,

There is no backward compatibility with sql 2005.

You cannot Attach or Restore sql2005 db to sql2000.

The only available option is SSIS to import/export data from

2005 to 2000.

Hope this helps,