yes. But now it is failing...

That to it is working fine in some days but failing in some day's n the days are also are not specific days.

That's is problem...

Hi All,

Am asking about something related to server configurations when going to sql 2008.

I mean like turning on AWE for memory.

Thanks!

Thanks for the help.

I have attached the original UPDATE query and EXECUTION PLAN in my previous post.

I think it the one we need to figure out.

I removed the ltrim and rtrim fuctions in the subquery and executed the update then it is getting executed very fast with 2 mins.

As per my knowledge, the indexes will...

No.

How can i confirm whether my update stats are done correctly or not?

Because i have a job which runs the update stats midnite. it shows it is completed successfully.

But when...

Here is the table count and UPDATE look like this

select count(*) from table_1

select count(*) from table_2

select count(*) from table_3

select count(*) from table_4

/*

39621

39340

18975

40335

*/

UPDATE dba.table_1

SET gp =...

done the following from my side.

1. On the 2000 server start the remote registry windows service.

2. enabled the remote allow connections on the 2000 server machine

3. added my user name...

Thank You.

For that reason only, i asked you!

Hi Gila,

Here is what is there in ERRORLOG. How to bring back my instance.

Any suggestions?

ERRORLOG.TXT

2010-01-21 13:06:30.61 Server Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (Intel...

Super thanks!

Thanks Jason.

Thank You.:-)

Absolutley right!

Let me revise the script and see what it takes.

Thank you so much.