Eirikur Eiriksson wrote:

Interestingly, it looks like you have been spending 9 years counting 😉

😀 What can I say? If I can't count of how SQL counts, how do I do any...

• This reply was modified 2 years, 1 month ago by  ashkan sirous.
• This reply was modified 2 years, 1 month ago by  ashkan sirous.

Hi Eirikur

Thanks a lot for the reply. I ran the query with the maxdop 1 as you suggested and I can see that the Data IO percentage (max) dropped to...

• This reply was modified 2 years, 1 month ago by  ashkan sirous.

Thanks a lot everyone for the awesome guidance. I have added the missed information in the question. I have asked for permission to look into production database's query store so...

Thanks a lot Jeff for the reply.

I've added a normal column and copied the value in it. I was expecting to see the same result as a persisted computed field...

• This reply was modified 5 years, 4 months ago by  ashkan sirous.

Thanks Arthur! Worked like a charm 🙂

Sorry for the bad topic name.

I tried 3 times to save my question and it succeeded, but then it has been removed from the forum after 10 second. I...

Hi Hugo,

Thanks a lot for the reply. I think that is enough for me. Could you please guide me how to do it?

I need to see what was the amount...

old topic, but it helped me find my solution

Thanks a lot

I use dbcc opentran to define what is the id of the open transaction and then I used this query to see the information of that transaction

SELECT *

FROM sys.dm_tran_session_transactions tst...

Dear GilaMonster,

I'm sorry , we only insert to our tables throw code, and we...

Well, I know it is better in general, but what I want to say is that I cant find any major difference between them when the maximum rows in the...

Dear opc.three,

Thanks for responce,

this is the insert part of my webservce.(using c# .net )

the file sends to the webservice in a datatable

byte[] fileContent =(byte[])...

Thanks , but does it make any sense that you have it on your sql job list?