Can you post the deadlock graph?

If you do not already have one captured enable trace flag 1222 and then one occurs again you can retrieve it from the SQL Error...

david.ostrander (2/13/2013)

---

Hello -

Developers at the company I work for want to access one of our databases to create an iPad app for entering your timecard. I have a copy...

konstantinov.maxim (2/11/2013)

---

There is an example I thought up:

Transaction 1 started first It changes the value from 0 to 1, Transaction 2 started second It changes the value from 1 to...

Page file access patterns are mostly random. Think of them as an extension of physical RAM (Random Access Memory).

It depends on whether you want to control what goes in each physical file or whether you want to let SQL Server control that. If you add more files into...

sweniosSqlSeeker (2/13/2013)

---

Hi all members,

To know what I mean, PLZ do the Following:

1- Open the sql server management studio.

2- Point to any user database, then press the right click.

3- Choose "Tasks",...

Can you please clarify what you meant in the title by "data source types"?

zi (2/13/2013)

---

Dear Experts

I am just trying to test this agent cmd job msg "%username%" "HI"

but an error said that this user is not existing or disconnected

Any idea to to solve...

Have you checked the MAP FAQ and MAP Forum pages available from the page I linked to?

That's kind of what I was getting at...either someone else went in there...

I am not exactly sure what you're after but if you provide two sample XML documents and your expected results per your thoughts on the filtering and joining requirement you...

One way:

SELECT abc.*

FROM dbo.abc

JOIN dbo.xyz ON dbo.abc.id = dbo.xyz.id

WHERE EXISTS ( SELECT TOP 1

...

Just confirming, you did not put the DB into emergency mode yourself, correct? It just came up that way after the restart?

Is there anything in the SQL Error Log related...

Mail logs due to spikes in activity are a common reason. Job and backup history are others but those do not typically cause sudden jumps, usually more gradual growth.

Did the server crash? What were the circumstances around the service restarting?