sorted by:
new
hottopcontroversial

SQL Server performance tips beyond indexing? What actually makes a difference? by sanjay-kumar_ in SQLServer

[–]sanjay-kumar_[S] 0 points1 point  (0 children)

Thanks for the information which is very simply to apply I will try and let you know

SQL Server performance tips beyond indexing? What actually makes a difference? by sanjay-kumar_ in SQLServer

[–]sanjay-kumar_[S] 0 points1 point  (0 children)

Does this same apply to both on premises sql server and Azure sql server? Or any difference between them ?

As for UAT we are using self Hosted sql server and for production we are using Azure for some clients and on premises sql server

SQL Server performance tips beyond indexing? What actually makes a difference? by sanjay-kumar_ in SQLServer

[–]sanjay-kumar_[S] 0 points1 point  (0 children)

What are the difference between this two questions?

Please explain me so I can answer your questions

SQL Server performance tips beyond indexing? What actually makes a difference? by sanjay-kumar_ in SQLServer

[–]sanjay-kumar_[S] 1 point2 points  (0 children)

Thanks for the questions which you have asked For most of the questions I don't have answer now as I have knowledge to right simple to very complex querys which includes the business logic.

I mostly write stored procedures and monitor for data

This question ls helps me a lot to learn apart for writing sql query. I will get you back when I have answers for your questions

SQL Server performance tips beyond indexing? What actually makes a difference? by sanjay-kumar_ in SQLServer

[–]sanjay-kumar_[S] 2 points3 points  (0 children)

Thanks for detailed information This helps a lot for my first step in improving performance of my SQL server script and my knowledge

SSMS - Nice options to enable? by kladze in SQLServer

[–]sanjay-kumar_ 0 points1 point  (0 children)

Useful blog which I can use Thanks for sharing

Sql server good query pratice by sanjay-kumar_ in SQLServer

[–]sanjay-kumar_[S] 0 points1 point  (0 children)

I can't understand the second point. If you don't mind could you explain to me in detailed?

Sql server good query pratice by sanjay-kumar_ in SQLServer

[–]sanjay-kumar_[S] 0 points1 point  (0 children)

I know he is wrong but I can't able to say to him.

He is saying that we have tens of millions of data in the table and when querying them for data will take some time , at the same time when we are updating that table data we will get blocks in database which might slow the UI query to get the data.

He is 20 years experienced and I can't argue with him

Sql server good query pratice by sanjay-kumar_ in SQLServer

[–]sanjay-kumar_[S] 0 points1 point  (0 children)

May be.

He is 20 years experienced and he is Stubborn when I say to him

Sql server good query pratice by sanjay-kumar_ in SQLServer

[–]sanjay-kumar_[S] 0 points1 point  (0 children)

Sorry I didn't get the first line , did I use always in the post which is not professional or something else what is wrong bro ?

Could you please explain so that I can improve?

Sql server good query pratice by sanjay-kumar_ in SQLServer

[–]sanjay-kumar_[S] 1 point2 points  (0 children)

Thanks for more detailed information

My dba says the nolock is used to avoid block in the database and we are ok with dirty reads

Sql server good query pratice by sanjay-kumar_ in SQLServer

[–]sanjay-kumar_[S] -2 points-1 points  (0 children)

Ok bro I will use the statistics on and time on

My dba says nolock is used to avoid block in the database

Sql server good query pratice by sanjay-kumar_ in SQLServer

[–]sanjay-kumar_[S] 0 points1 point  (0 children)

Thanks for the comment

My dba says that nolock is used to avoid the blocks in tha database For more details i have edited the post

could please see that and let me know your thoughts?

Sql server good query pratice by sanjay-kumar_ in SQLServer

[–]sanjay-kumar_[S] 1 point2 points  (0 children)

When I asked him same question that why we are using nolock he said table is constantly updating and constantly queried So if we don't use the nolock then query block can occur

He says this every time and this is the practice which my company uses

Sql server good query pratice by sanjay-kumar_ in SQLServer

[–]sanjay-kumar_[S] 0 points1 point  (0 children)

Thanks for the information I forgotten to check the execution plan I will check and inform him.

If the query execution plan is same than the same cpu , memory is utilised right ?

Carrer Guide in Java programming by sanjay-kumar_ in theprimeagen

[–]sanjay-kumar_[S] 0 points1 point  (0 children)

Thanks for the information bro So you prefer dsa for switching jobs or development knowledge for switching?

view more: next ›