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.

If you always need to search by Symbol and Date, change the PRIMARY KEY to [Date] ASC, [Symbol] ASC. I'd even recommend to makes this the clustered index (assuming you...

As an alternative you could use the CrossTab syntax as described in the related article in my signature.

If you'd need to add some flexibility, use DynamicCrossTab (a related article is...