Actually while deleting 50k records one at a time, the table getting locked and affecting other processes as well.

The fragmentation level in tables looks good to me. The only difference I can see is in number of rows sample in statistics based on clustered indexes. Currently it shows...

Hello All, Sorry to bring this thread alive again. Just wanted to let you all know that we did lots of code changes and finally it looked like problem is...

Hello All, I don't know why but changing the order of join made the difference. The query is running quite fast now. How does it works anyways ? Anyone ?

Thanks John. One more doubt. Can we only use Mixed mode authentication for non windows user/applications ?

Nope, Its on selective basis. And Yes, its in same order in each environment.

All of them, but getting errors in all cases. Interestingly, same definition defined in other environments as well but deletion happening successfully.

I am getting these errors in three tables. Say TabA, TabB, TabC. PK of TabA is referenced by FK in TabB and PK in TabB is referenced by FK in...

I ws actually looking from same point of view. To reduce lockings. However just this factor does not justify to have different sql instance on same server or does it...

Point 2: Usually organizations have different Domains for different regions. So if we have to create any NT group to get people access on SQL box through Windows NT authentication,...

One more thing:

4. How is service account different from normal login [of course apart from their functionalities like Service Accoutn should be used only by application and Login is for...

There is a varbinary datatype as well. Can this be the issue for filling up the tempdb ?

Strangely what I can see here in my case is, its getting stuck everytime in case of one particular table which has total around 70k records and out of which...

There might be possiblity. How its going to effect in this scenario ?

Thanks Gail. I'll look into the detailed functionality of triggers. However this creates one simple question in my mind. Suppose we have one table TableA with 100000 records and our...