Question:The specified task executable "LC.exe" could not be run. The filename or extension is too long
Description:Getting this error when get latest a TFS project on fresh machine "The specified task executable "LC.exe" could not be run. The filename or extension is too long", the project was working perfectly on my old machine
Posted by: Samantha Jones | Posted on: May 17, 2019
Question:update or alter a stored procedure programmatically through C# code
Description:I have to update a store procedure on live site and we don't have the access of the database at our development environment so we need to do this through code in C#. I have search a lot but unable to find a proper solution For example , I have a following stored procedure, ALTER PROCEDURE [dbo].[SelectCustomers] AS BEGIN SELECT * from Customer order by Customer.DateCreated DESC END And I want to update it to the following one ALTER PROCEDURE [dbo].[SelectCustomers] AS BEGIN SELECT * from Customer where Customer.Status=1 order by Customer.DateCreated DESC END
Posted by: Junaid Aziz | Posted on: May 09, 2019
Question:google's distance matrix api throwing MAX_DIMENSION_EXCEEDED exception
Description:I have used google distance matrix api to calculate road distances from my place to some near by places it was working fine when I have tested the code but when we have increased the number of records it has started giving the "MAX_DIMENSION_EXCEEDED" exception it seems that one can't calculate more distances as I have nearly 200 destination in total for which I have to calculate distances need help.
Posted by: Umer khan | Posted on: May 09, 2019
Question:In a many to many relationship, get records of table A associated with more than N number records of table B?
Description:I have Table A(assumed as Student) and Table B(assumed as Course) with their junction Table AB (StudentCourse),For example considering the following tables I need to get all the students with their Id and name who have enrolled in more than three(N) courses |Student| |Id | |Name | |Course| |Id | |Name | |StudentCourse| |Id | |SId | |CId |
Posted by: Samantha Jones | Posted on: Apr 17, 2019
Question:How to maintain consistency in a variable that is shared among several threads in Task parallel library?
Description:I am using task parallel library to run a for loop on all of my CPU cores, but I am just thinking that the resultant of all the operation performed is not going to be what I want? Is there a way to perform operations on a class level variable shared with multiple threads so that the answer of Parallel.For() doesn't return inconsistent value! For learning purpose I have written a simple code chunk as follows which is always returning less than 10000000 int total = 0; Parallel.For(0, 10000000, (i) => { total++; }); Console.WriteLine(total); Console.ReadKey();
Posted by: Peter Andre | Posted on: Mar 15, 2019
Question:what is purpose of using async or defer attribute ?
Description:what is purpose of using async or defer attribute on script tags or files and on css files and what is the difference between async and defer attribute and how to use them to efficiently load my scripts and styles.
Posted by: Umer khan | Posted on: Feb 11, 2019
Question:difference between value type and reference type with example in c#
Description:recently I have gone through an interview where I have been asked why a software developer should know about the difference between value type and reference type, by definition I know both terms but what are the condition where I have to choose any one of them and the other couldn't do the same thing for me ?
Posted by: Samantha Jones | Posted on: Feb 08, 2019
Question:Glyphicons with Bootstrap 3 not working on some browsers randomly
Description:I have tried so many solutions by changing the font paths and I have verified that my fonts are always loading perfectly fine but still my icons sometimes shown broken. for example I have used class "glyphicon-log-in" which was sometimes displayed as "î…¡"
Posted by: Peter Andre | Posted on: Feb 04, 2019
Question:what is the difference between view and Stored Procedure (view vs stored procedure) in sql?
Description:Need to know the difference between the two in terms of which should be used in what conditions, according to my current research similar operation can be achieved using any of them
Posted by: Junaid Aziz | Posted on: Jan 25, 2019
Question:how to redirect dynamically from mvc controller method with status code 301 instead of status code 302?
Description:In my code I am redirecting to new url which is current url appended with the url slugs but when I see in my browser it always gives status code 302 which is for temporary moved redirects but I need to move it permanently with status code 301 is it possible from controller method?
Posted by: Peter Andre | Posted on: Jan 25, 2019