siddartha pal (9/22/2009)

---

Could you please arrange to answer the followingt things in respect to the dead lock graph posted:-

1:There are 4 process involved but the no of process nodes appearing...

This node, along with another, had a deadlock, on a page, 6:1:96560 (databaseid:fileid:pageid). This node is the victim, the spid that got killed and rolled back. Based only on the...

Either the path where backup is placed doesn't exist or context under which SQL Server is running doesn't have access to it.

Or, it's the issue that SilverFox spotted.

Cost is how much the query costs, on average, to run. The user impact is how much of that cost is going to be saved or reduced. They're definately different...

It's blank. If you're posting XML, you need to use the code listing on the left

[ code = "xml" ]

Just remove the extra spaces.

Sorry, I can't read it. It's too small and the resolution isn't high enough for me to make out the words even after I blow it up.

In general, the narrower the index, the more keys that get packed on to a page, the quicker the seeks. So, with the INCLUDE, you're taking two columns out of...

Less, but the article length requirement here is not as long. You don't go through a...

I'm not sure how high the standard...

Yeah, you can't really directly compare one execution plan to other as such, you just evaluate each one to see if there are issues.

Yes, it's a Star Fury. B-5 is...

Assuming this is a multi-statement query, you could try capturing the Statement completion event within a trace. It's going to return an awful lot of data, so you need to...

Although, usually, half as many reads is pretty much the end of the story. I'd check the execution plan though, see what differences there are there.

Maxer (9/21/2009)

---

Say I have two tables, both are the same.

Table1 and Table2.

I UNION both and add a column called "Origin" that says "Table1" for table 1 and "Table2" for table...

I'm sorry, I'm reading through the code there and I'm not sure what your error message is.

Lynn Pettis (9/21/2009)

---

Grant Fritchey (9/21/2009)

---

You do.

We get exclusive rights for... some period of time I don't recall, a...