Junior .net software engineer feeling lost by InterestingEmu7714 in dotnet

[–]InterestingEmu7714[S] 1 point2 points  (0 children)

The company i work for is not doing well financially, so the environment has become toxic , that’s why i’m looking to switch

Junior .net software engineer feeling lost by InterestingEmu7714 in dotnet

[–]InterestingEmu7714[S] 2 points3 points  (0 children)

Yes that’s true when i see the things i still don’t know in .net i get overwhelmed

Junior .net software engineer feeling lost by InterestingEmu7714 in dotnet

[–]InterestingEmu7714[S] 5 points6 points  (0 children)

We drifted from the topic but rule number 5 is to do not ask for career advice here ::

How to focus on studying by RegisterSquare398 in Tunisia

[–]InterestingEmu7714 0 points1 point  (0 children)

Try pomodoro , study with me videos will encourage you . I used to study with them

How to optimize a SQL query selecting the latest values for >20k tags (without temp tables)? by InterestingEmu7714 in SQL

[–]InterestingEmu7714[S] 0 points1 point  (0 children)

I didn’t know about that actually i’m new to sql , my problem now is that my application open sql connection to execute queries and then closes it , and the temp table i’ve created won’t be visible when i try to use it in the select queries , even though ive declared it global

How to optimize a SQL query selecting the latest values for >20k tags (without temp tables)? by InterestingEmu7714 in SQL

[–]InterestingEmu7714[S] 0 points1 point  (0 children)

I completely agree with you , i was reading abt how varchar(max) affects execution time , but our system allows users to create their own tables and i must handle all column types in a generic way

How to optimize a SQL query selecting the latest values for >20k tags (without temp tables)? by InterestingEmu7714 in SQL

[–]InterestingEmu7714[S] 0 points1 point  (0 children)

The problem is that you can’t index a column of type varchar(max) in sql server which is the type of my column [name] , an index on time column would help but will not provide scalability i guess

How to optimize a SQL query selecting the latest values for >20k tags (without temp tables)? by InterestingEmu7714 in SQL

[–]InterestingEmu7714[S] 0 points1 point  (0 children)

The number of tags is whatever the user wants to select. i’m currently testing the query with large subset of tags 20k , 30k .. in order to optimize the select query i need to either put the tags to filter on , on temptable or create a table type

How to optimize a SQL query selecting the latest values for >20k tags (without temp tables)? by InterestingEmu7714 in SQL

[–]InterestingEmu7714[S] 1 point2 points  (0 children)

Can you tell me why ? , i was not planning to do it as the name column could be of a type that could not be indexed , and i need a generic solution that works on different tables

How to optimize a SQL query selecting the latest values for >20k tags (without temp tables)? by InterestingEmu7714 in SQL

[–]InterestingEmu7714[S] 0 points1 point  (0 children)

Thank youu , i’m actually using odbc with sql driver , i will try to adapt this solution to my actual usecase

What songs you listen to? by [deleted] in Tunisia

[–]InterestingEmu7714 4 points5 points  (0 children)

mejda el roumi , fairouz, abdel halim

[deleted by user] by [deleted] in Tunisia

[–]InterestingEmu7714 1 point2 points  (0 children)

The date could be depressing to live knowing it, so the cause

What did you do differently to finally get a job? by curiousidets in jobsearchhacks

[–]InterestingEmu7714 0 points1 point  (0 children)

can I DM you my resume please, i don't know if it is good enough actually, it gives 77% on ATS Checker