Found this issue when a stored procedure was taking it too long to execute and the same query inside the proc took fraction of a second. Never seen this before did some searching and found a simple fix. Add option (recompile) at the end of the query and voila problem resolved.
Use the combination of three for an exclusive rowlock that is held until the end of the transaction
There has been a few tricks. One of them is to update the registry setting. Add the following key using your registry editor.
Windows Registry Editor Version 5.00
Other small trick is to use a performance counter. There is a counter called \Process\ID Process. That will identify the process id of the “w3wp#N”instance you’re looking at.
You can use on run: c:\Windows\system32\inetsrv\appcmd list wp to get the list of w3wp processes and their relevant process ids.
Hope it helps
Find this new app on google play. A great todo, daily tracker.
here is the app link on google play. From the author of this app. HabitRPG is a habit-building program which treats your life like a Role Playing Game. Level up as you succeed, lose HP as you fail, earn money to buy weapons and armor, compete with your friends.
I am loving it so far. Do try on your smart phones
Here is a scoop; The good software engineer is lazy!
You don’t believe me? Then ask yourself this: If a good software engineer was not lazy why would he:
Yet, here is another scoop; The bad software engineer is lazy too!
While this statement clearly isn’t a shock to you, it immediately pop-ups the question:
What is the difference?
The difference is that a good software engineer is lazy in a constructive way (which allows to build reusable software and automated processes) while a bad software engineer is lazy in a destructive way (which destroys any chance for a reusable software and dooms you for long hours of struggling to understand and fix the bad code).
And here is a short example:
The var keyword allows implicitly typed variable declaration.
To tell the truth, it doesn’t allow to be a bad lazy software engineer!
Why bad? Take a look at the code below:
var database = DatabaseFactory.CreateDatabase();
What is the meaning (meaning = type) of the database object in this context? Do I really need to guess that? Does somebody expect me to go to its definition to find out?
foreach(var observingStore in wareHouse.Stores)
What is the meaning of the observingStore object in this context? Was it named observingStore due to its implementation of the Observer pattern (which implements IObserver), or is it just an object name of a Store, ObserverStore or even ArgicultureStore class type?
Remember, you want to be lazy in a constructive way; You want to read those lines of code without wondering. You want to immediately grasp the meaning (types) of the objects you are dealing with, without switching the context and jumping to a different location just to refresh your memory.
The var keyword was introduced for one and one purpose only; To allow usage of anonymous types. Therefore, this is the only place you should use it! Unless you are a bad lazy software engineer (which clearly is not the case 🙂 ) you will follow the rule!