Hi The _SQL_DBA,

its not a problem i have faced. I need 2 know what may happen for this problem and the possible work around 4 that. Is locking may cause...

Hi,

I have told in my first post, this is an ineterview question. I need to know what may happen and what may be the work around.

what I think, it...

Hi,

Thanks for your reply.

It is working yesterday night fine. Meanwhile there is not such bulk insertion etc. So index should not be a factor.

Also other reports are working fine....

Thanks 2 everybody. Currently we are testing with SNAPshot isolation.

I ll post the details after this tesing i.e. code and table structure.

I am not a very experienced guy, still I never faced this things in production.

But the thing is, i have faced the same question twice in interview. May b...

Hi,

We have identified the objects where dead lock is hapening. While deleting in one table and simultaniously updating and inserting it happens. We have made it SERIALIZABLE isolation but no...

Thanks gail, I ll try your solution also.

Hi Gail,

This is actualy a question, which I have faced in an interview. I have tried with ROW_Number function later but no result.

That's why I have posted it. Its...

HI Avijit and Vikas,

Thanks for the help. This is exactly what I need.

Thanks again.

Hi Gail,

I am switched to DBCC 1222, but not able to generate any graphs. Infact not able to reproduce the deadlock issue. It happens which testing team is testing...

Hi Adi and Nitin,

many thanks for the help. Now its working fine.

Thanks again.

Frankly speaking, in one oracle interview , I have faced this question. Then I was starting to think to implement it in SQL server, but not getting any way.

I...

Very useful article. Easy 2 understand.

HI Gail,

I have tested with your script and here is the result:

SQL Server parse and compile time:

CPU time = 62 ms, elapsed time = 85 ms.

(157580...

Hi Gail,

I have done the same as per ur advice. Now scan count, logical read, physical read is same for both, but "SELECT *" is taking 12 ms but "SELECT...