2 physical, 8 logical. We can tell the # of each from SQL...

-- cpu overview

SELECT osi.cpu_count AS LogicalCpuCount,

osi.hyperthread_ratio AS HyperthreadCoreRatio,

...

I had this problem on SQL 2005 and could not do anything with the jobs in place so went this route to keep plan cache under control:

Plan cache, adhoc workloads...

GilaMonster (8/30/2012)

---

It'll be CheckDB with REPAIR_ALLOW_DATA_LOSS as no other repair option is allowed...

What kind of repair? You may have lost data that way. Can you post the exact command?

edit: and post output too if you saved it, from that we can tell...

rarara (8/21/2012)

---

Default database - on the principal it has the user database as the default for the logins, but on the mirrored server the logins list master as default. presumably...

If you're not planning to sell it might I recommend starting a project on CodePlex. I looked into writing an add-in for SSMS in 2005 at one point but the...

Greg Drake (8/30/2012)

---

I have had this problem before when I attempted to use a maintenance plan cleanup task to delete perfmon files as they got old. When it didn't work...

Hi roshanmaugustine. I am not trying to be rude here but I must say, I am sure that what you posted makes sense in your head, but reading it without...

Do you have a valid backup that does not contain the corruption?

At minimum you need to restore the corrupt page and possibly more pages leading to the need to restore...

You can capture DML operations (i.e. INSERT, UPDATE and DELETE) using TRIGGER. SELECT operations are a bit trickier. Are you using stored procedures for all data access? If so...

halifaxdal (8/30/2012)

---

To make things simpler, I feel this would be easier:

1. Instead of creating a fancy report, just create a stored procedure to generate a spreadsheet and use it as...

MoveOn

The issue it not necessarily in returning the...

PowerShell 2.0 is standard equipment in Windows Server 2008 R2. What are you...

Are you saying you created one stored proc that handles inserts, updates and deletes for over 100 tables using dynamic sql?