Databases only have 1 mdf file. They can have multiple ndf files (secondary data files)

Could you explain a bit more what you're trying to do? I'm not sure that I...

mark (5/20/2008)

---

Thanks for the reply.

So on that note are you able to tell me if it is "Best Pratice" to have a clustered index on a table? (as opposed...

Look up the REPLACE function in books online.

Lots of info on SQL 2008:

http://www.microsoft.com/sqlserver/2008/en/us/default.aspx

dbaInTraining (5/19/2008)

---

I think you kind of stumped me. I thought that was a best practice. If there was a need to restore, use the last full, then the...

A heap is a table without a clustered index. It may or may not have nonclustered indexes on it. You can rebuild nonclustered indexes that are on a heap, but...

What does the SQL error log say about the reason the database is suspect? There should be some evidence in there.

Be aware that if you recreate msdb, you will lose...

Looks about right.

I wouldn't worry about splittng files/filegroups unless you're noticing some form of IO contention

high numbers of pending IOs within SQL, high disk queue length (though that counter's fairly...

That's the no.1 reason I gave my boss when I told him I would be leaving...

Michael Earl (5/19/2008)

---

NOLOCK reads dirty pages, so by inconsistent data I mean your application may present data not only uncommitted data that could be rolled back, but you cound, in...

Compat mode can be changed up and down, no issues. All that happens if you drop...

More space. It's a second copy of the index. It will also mean more overhead on insert/update/delete as both indexes will have to be updated, rather than just one.

You can read the tran log manually, but it's very hard to understand.

SELECT * from fn_dblog(null, null)

SQL 2005?

You may have some luck with the ROW_NUMBER function. Try partition by PER_ID, order by Sch

mobasha (5/18/2008)

---

if u want u can choose the most accessed tables then rebuild the indexes manually,

then update thier statistics with full scan.

thats only if u want to gain some time...