I don't think I'd use 50. It'll have the same problem as 5 - poor write performance due to the parity stripe. Each write may incur up to ((no of...

You say partitioned. How many physical drives are we talking here? Raid? SAN?

If you want perfect...

Log file on RAID 10 dedicated array

Data file on RAID 10 (preferably) RAID 5 (acceptable)...

Tran log growth is hard to predict. As well as the data, there are log headers, internal allocation pages that need logging, etc. Plus, if there was other stuff also...

Linked servers and remote queries are an excellent way to slow things down.

Why do you want to split the DB up? If the hardware is correct, the design is good...

sal527 (12/2/2008)

---

i have written a trigger which auto generates the proj_pjid when project is created ex: new project number will be '664', it generates the id with respect to...

Excellent!

It may be an idea to run checkDB a little more frequently. Weekly, if you can afford the time, otherwise do some databases one weekend,...

Depends what you mean by a DBA. If you're taking about someone that watches jobs, runs backups and deploys changes only, then maybe their job will disappear. There's a lot...

rajeevtenneti (12/2/2008)

---

Unfortunately it was decided to move on to MSSQL backups and we tested on

a development dtabase a db of 40Gb with 38GB data takes 37GB on...

Don't use the database migration wizard. That's a really long way.

Take a backup of the SQL 2000 database and restore it on 2005. Once you're restored, rebuild all indexes and...

Can you backup top the local disk and then copy the backup to take.

Please post SQL 2000-related questions in the SQL 2000 forums. If you...

What about the other index, on OUTP_54?

Ok...

I think that this whole mess can be fixed by dropping and recreating two indexes. I'm not going to promise it will, I'm a bit unsure of the meaning of...

It's a built-in function that returns a resultset of the records currently in the transaction log.

hemanth.damecharla (12/2/2008)

---

Not...

The SQL 2005 parser is a lot stricter about what it considers valid SQL. Technically, that syntax isn't valid, but the 2000 parser would accept it, even though it could...