Can you attach the plan as a .sqlplan file? (I'm getting an invalid character error when trying to open the file...)

tfeuz (12/28/2010)

---

Lutz,

A couple of quick answers before I get to posting the plan...

- I do not think it is a query optimization problem. The query runs relatively fast...

Is there any chance for you to post the actual execution plan for the SELECT statement being part of the deadlock?

My shot in the dark would be the SELECT is...

The current output looks straight forward in terms of a table output. You have two columns with the corresponding values.

It seems like your question is more related to a reporting...

lsurapaneni (12/28/2010)

---

I am not getting the output in desired format.

I tried the solution that you provided. Do I need to do nested xml? to get the nodes as below:

...

abhishek.8604 (12/24/2010)

---

use sql profiler..tune all your queries/sp which are taking more time by applying recomendations given by the tuning advisor..if it still does not work then check in books online...

You might want to have a look at Gails article.

At least this should get you started.

From my point of view, performance tuning is an art all by itself. No secret...

I would need a sample file and the target table structure as DDL scripts so I have something to test my solution against.

I don't like option 1 because you can almost always have a scenario where the requirement exceeds the sparse columns defined (unless you define a large number of columns which...

In that case, I'd still go with the XML column. Index it, so it won't be that much of a pain to query the data. And make yourself familiar with...

The good part of it: you catched it before the Holidays. So you don't have to worry about it anymore. And I'd be surprised if there would be a single...

I just tried the following sample code:

SELECT CONVERT(datetime,'12/05/2010 9:30:00.000') AS 'TheTimeIn',

CONVERT(datetime,'12/05/2010 9:35:00.000') AS 'TheTimeOut'

and it returned 0 HRS, 35MINS and 30 AwardedMinutes.

Are...

Have a look at BOL, section "reorganizing indexes".

You can also...

A similar question would be the current design of the upload process. If it's RBAR based (any kind of a loop) there might be the issue right away.

We'd need to...

If it's an interview question, try to answer it by yourself and do some research on it.

Post your answer and see what others think about it.