Looks like the restore statements were specifying the wrong files. Post the restore statements you used.

No

2)Does the file group can be used to increase the performance of sql server if...

Could well be that the stats that the query depends on are column stats, not index stats. REbuilding an index only updates the stats associated with that index (and invalidates...

Deadlocks are mostly caused by poorly written queries and inadequate indexing, not hardware, recovery models, fragmentation or memory stats (though they can have an influence, except for recovery model that...

MyDoggieJessie (1/15/2013)

---

Gail, I sincerely appreciate your insight. One last point to clarify:

Restore master, that will recreate all the user DBs that the old instance had (providing you left the...

They're called "Checkpoint Begin" and "Begin Time", not in the old DBCC Log though, in the undocumented function fn_dblog

Other way around. This isn't something you add to a table. Rather you move the table into a separate filegroup and mark the filegroup read only (tables can't be read...

I strongly recommend against this approach. It's a security risk and a maintenance nightmare. You wouldn't develop a C# method that could handle customers or products depending on a parameter...

The Checkpoint begin has a time, so does the begin transaction log record. The transaction log is not an audit log, the log records don't all need to have datetime...

You've got redundant indexes there. The 2nd and 3rd are identical, you should drop one of them.

For the revised query that I gave you, you probably want one of these,...

Lynn Pettis (1/15/2013)

---

george sibbald (1/15/2013)

---

sjimmo (1/15/2013)

---

Lynn

To restore to 1/13 4:00 AM you will need the previous days (1/12) full backup file plus all the t-log backups since that backup up...

Current index definitions please.

MyDoggieJessie (1/15/2013)

---

So a workable process would be to:

1. Take full backups of all User DBs and the Master, MSDB, and Model DB

2. Completely uninstall SQL Server

3. Re-install

4. Restore all...

Full backups do not and never have broken the log chain,

My understanding is that once...

Please post index definitions (they're not in your script) and execution plan (not the picture of it), as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Also, you can simplify that query as:

select

eln_payslip,

edamount

from dbo.tbl_Penyata

where nogaji='047911' and edtype='01'...