Posts
Sort by recent activity
How to create a snippet that uses table metadata?
I would like to write the following sql via a snippet: SELECT TOP 10 * FROM dbo.Documents d ORDER BY 1 DESC So to do this, I have a snippet: SELECT TOP 10 * FROM $CURSOR$ ORDER BY 1 DESCHowever, I ...
How to get SQL Prompt to add (NOLOCK) when inserting a join?
Consider the following snippet:When I select CustomerPerson from the dropdown, is there a way to get SQL Prompt to add it with (NOLOCK) statement? I've looked through options and haven't found any...
Ants Performance Profiler 10 says Trial Expired.
I downloaded Ants Performance Profiler 10 to try it out. However, it gives me this error.
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...