Posts
Sort by recent activity
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...
Do snippets support multiple variable expansion?
When I read snippets, I assumed SSMS or VS style snippets, except with less PITA experience. Unless I am missing something, the snippets in SQLPrompt5 are a more limited replacement. Please tell ...
How does one profile a WCF Web Service?
I have Ants Performance Profiler 5.2 (I couldn't find a forum specific to that).
I have a WCF Service project. It has several .svc files in a Visual Studio 2010, .NET 4.0 project. I am having tro...
Can't figure out how to profile my web services application.
I have a web services application that pretty much consists of .asmx pages separated by folders.
I can't figure out how to profile it. Specifically, I don't know what to enter for the ASP.NET web a...
I don't get this.
Note the image. .
It says that GetWidgetsFromDb method took 0.803 seconds
However, below you can see the actual GetWidgetsFromDb method and the only statement there took 1.038 seconds.
What's missi...
Confused as to how to interpret the readout
I am profiling an app with ANTS 5.2.0.26 and I am getting a pretty unbelievable number from the WinForms app.
It seems that setting System.ComponentModel.IContainer to null (code generated by the d...
How do I profile a specific method?
It does not even show up in the tree/list, but it is really important to me. Using 5.2.x
Why is the ANTS 5 menu grayed out in Visual Studio 2008?
At some point, the menu became disabled. The number of buttons on the ANTS 5 toolbar went down to 1 ('Profile Performance').
How do I re-enable it?
VS2008 with all latest service packs on WinXP wi...