excessive parallelism?

compare the query plans on the UAT and prod servers and go from there.

I don't know how big your shop is but the first action should be - appoint an incident manager if the incident is serious enough (you would have to have...

afraid not. A restore of an online database has to start with a full restore, so you will need another full backup or use the old full backup again.

If you...

opc.three (4/15/2013)

---

Given that this was a 2000 DB and UPDATEUSAGE had not been run, it compels me to ask you if you have ever run CHECKDB WITH DATA_PURITY. If you...

ben, you seem to have ended up with two threads, I am going to ask people to reply to the other one here to keep things together

with QOTD I have learned to straight away look for the keyword identity when I see column name ID. 🙂

are you using the gui to view it? If you use sp_readerrorlog in the SSMS query window it will display it oldest first

<sigh>

:doze:

sharepoint 2010 does not seem to be a big user of tempdb. I have one installation with an initial size for tempdb of only 200mb and there has never been...

so, to confirm, you were also able to resolve this issue by removing a WINDOWS security patch? (2661254)

this looks like a good article concerning this problem

I'm confused, which KB did you uninstall, (neither number seems correct) and was it a post SP2 patch?

I am struggling to remember if it was after SP2 (I think it was) but i certainly hit the same problem where SSRS did not start and there were no...

here is a link to a set of instructions - http://www.mssqltips.com/sqlservertip/2464/configure-sql-server-database-mirroring-using-ssms/

before setting it up though read up on the various operating modes and decide which you want and wether you...

I'm with ed44 on this, very likely to be permissions (OS error 5).

check your SQL server errorlog for more information on the actual cause of the error.