Change it to real.

You have to put "C:\Windows\System32\cmd.exe" in executable

How long does it take to run if you skip report status?

Paul you just have to add body_format = @variable.

[ @body_format= ] 'body_format'

Is the format of the message body. The parameter is of type varchar(20), with a...

Chris try disable/rebuild index it should perform faster than drop/create.

I don't know your underlying disk structure but for best performance you should separate all your indexes from the data file...

Can you post partition function and scheme scripts?

You can script them from the DB>Storage folder.

I think you can setup a group policy for a service and add a user to that group not sure if's its locally on the server or in AD.

But if...

How did you do this?

It depends on your environment/application/db size.

If you can schedule down time then detach/copy/attach will work (copy time must be taken into consideration)

If you have 99.999 policy detach/attach is impossible...

alen teplitsky (7/20/2011)

---

this table is a subscriber with 150,000,000 to 300,000,000 rows depending on the time of month. sometimes we have a big batch process that deleted tens of millions...

halifaxdal

you may want to take a look at this.

http://www.sqlrecoverytool.com/sql-data-restore.html

trial version lets you view corrupted DB.

Grant Fritchey (7/18/2011)

---

AlexSQLForums (7/14/2011)

---

I usually use DTA when i have no documentation about a database that's having performance issues.

it does recommend creating indexes on every column in the where clause...

jpSQLDude (7/13/2011)

---

We are actually moving to DCB, but we only have a limited maintenance window to do the move. So we...

I usually use DTA when i have no documentation about a database that's having performance issues.

it does recommend creating indexes on every column in the where clause and depending on...

Sure you do in /server properties/database settings.