Posts
Sort by recent activity
How to profile a website that has custom applicationhost.config?
I have Ants Profiler 8.6 (though I have no idea how to do this on the current version either). I have a solution in VS2017 that has
several web applications (some are webforms, some are just api ...
How to profile a website that has custom applicationhost.config?
I have Ants Profiler 8.6. I have a solution in VS2017 that has several web applications (some are webforms, some are just api end points) with a custom applicationhost.config in the %solutionDir%\...
How do I find which account the product was purchased with?
I have a RedGate product and a serial number. I've had it for a good long while. I've been thinking about upgrading it but I can't figure out which account or email address it was purchased with....
Don't get intellisense due to login error. Why?
I get intellisense for every other server in the enterprise, except for this one. The SqlPrompt/Help/Show Log menu yields the error below.
I can login to the box fine in SSMS and can run queries n...
Having trouble fully understanding the results grid.
If you look at the image below, for the Public.Listing.ListingSearch.OnLoad, Time with self is 4.016. Does that indicate the time that the code spent in that method, excluding children? Time to a...
IIS Site crashes when profiling with Line & method level timings (only methods with source)
I use IIS-ASP.NET profiling type with Line & method level timings (only methods with source). I fire up the profiler and get an unhandled .net framework exception in w3p.exe. https://i.imgur.com/...
What is the best way to upgrade while keeping all settings?
I am upgrading my sql servers from 2012 to 2016. Therefore I am upgrading from SSMS 2012 to 2016. And consequently, I need to upgrade SQL Prompts from 5.x to 7.x (since former doesn't support SQL...
How to disable SQL Prompt for unsupported servers?
I am using SQL Prompt 5.3.8.2 with SQL Server Management Studio 2012.
Occasionally I connect to SQL Server versions 2014 and 2016. I am greeted with this error
Is there a way to disable to SQL Pro...
Can "Format SQL" not throw JOIN conditions on the next line?
I have the following code:select p.x1, g.x2
from pTable p
join gTable g on p.EmpID = g.EmpID and p.SiteID = g.SiteID
Whenever I run Format SQL, it throws the second JOIN condition onto a new line...
I don't understand the results of the trace.
I am trying to run down some perf issues in my app. So I select a time period and get this:
I click on the highlighted line and get the following in the source view:
I don't understand how instant...