Thx, it's working now.

THX.

i didn't see in the OLE DB that i have the sql command instead i use the table connection.

Clive Strong (9/20/2008)

---

Have you manually checked the indexes & stats in question? You can see them from the execution plan.

Any significant fragmention in production?

Also, have you run sp_autostats against...

did any of you install the cumulative updates for SQL Server 2005?

should i install the latest cumulative updates?

if i install cumulative updates 9,does it include cumulative updates from 1 to...

completely the same.

use the same indexes.

I've changed the 'max degree of parallelism' to 1 that means only serially,i restart the server and i get the same poor results.

any other ideas what i can check on...

THX for all the replay's.

i did a backup and restore on the Test machine.

lets put the licensing issue beside.should it hurt my performance because it's Dev Edition?

the SQL Server build...

OK.but how i can prevent the user from login?

by issue a rollback or there is a deny logon syntax?

THX

Thx but this i know.

i need to see it in the query results.

is it doable?

and what about my first question? is it doable too?

THX

Lester Policarpio (7/31/2008)

---

Sorry for the late reply 'm so busy in my work. Maybe i can do something to modify the script. What do you want? different location for mdf...

Hi,

is there a way to update the script that i will tell where i want to put the LDF and MDF files if i want to separate them?

THX

i didn't format the partition through the command prompt instead i format it through the computer management but in the format i changed the Allocation Unit Size to 64K

and the...

Simon Facer (7/22/2008)

---

You may want to consider RAID 10, instead of RAID 5 for your SQL volumes - RAID 5 is not a recommended configuration. Also, dont forget to format...

sry. i figure it out after i post this message.

Thx.