How will a reputation system change that? Stack...

Uninstall, reinstall

Server names can be changed, instance names cannot.

Could you run this and post the results (attached as an excel spreadsheet will be easiest)

SELECT ddips.index_id, index_level, alloc_unit_type_desc, avg_fragmentation_in_percent, avg_page_space_used_in_percent, ghost_record_count, avg_record_size_in_bytes, forwarded_record_count, record_count, page_count

, au.data_pages, au.total_pages, au.used_pages

FROM sys.dm_db_index_physical_stats(<database...

Exactly, it's a page corruption, likely caused by some problem with the IO subsystem. Basically you have a dedicated extent (extent belonging to one object) that's marked as owned by...

SQL uses a variety of the LRU algorithm for the plan cache, so less-used plans will be aged out and removed.

I suppose you could schedule a job that ran the...

No. Not automatically.

You could restore another copy of the DB, roll the logs all the way forward and then use something like SQLDataCompare to see what's different and decide what...

There's a couple of undocumented commands that let you read the transaction logs,...

The upgrade (iirc) is from MCITP 2005 to MCITP 2008. Without the 2005 ITP, you won't be able to just write the upgrade exam and get 2008 ITP. You'd have...

Sumanta Roy (1/13/2012)

---

I have some doubts here on this topics.. Can someone please give some lights on this?

1. Why Microsoft dont take actions on those actual dumps providers when illegal?...

If you want the page density close to 100, then you'll have to set the fill factor to 100. SQL's not going to fill pages 100% when you've explicitly told...

Do you have a clean full backup (one without the corruption) and an unbroken chain of log backups?

The plan probably gets aged out of cache because it doesn't get used often. There's no way to force it to stay in cache.

Why is the plan being removed an...

In short, restore the following

8am full backup WITH NORECOVERY

10am log backup WITH NORECOVERY

midday log backup WITH NORECOVERY

2pm log backup WITH STOPAT '12:59:59.997', RECOVERY

One database restored to how it was just...

Hang on, why would you want to reduce page density? Page density is the average % of used space on pages, higher is usually good.

The reason it's around 80...

L' Eomot Inversé (1/12/2012)

---

edit: I haven't looked at the posting history - just the the thread referenced here and the first thread it references - so maybe I'm reacting on...