Skip to main content

Profiling with SQL Server Management Studio

On the Query menu, click on ‘Include Advance Execution Plan’ or click the toolbar button.

Now open a new query window, type the following queries and execute them.

use Northwind;
set statistics io on;
set statistics time on; 
Select top 5 * from Customers
 
You should be now able to see additional information in the message tab and execution plan tab (along with result tab in lower window pane)

Comments

Post a Comment

Popular posts from this blog

Solving PyCharm bug: "Python helpers are not copied yet..."

I have been using PyCharm Professional to run and debug Python code from my Windows machine to a remote Linux device. There are some other tools available for the same purpose (e.g. Python Tool for Visual Studio 2017). But in my opinion, PyCharm Professional stands out among its counterparts as it comes with a "All Batteries Included" setup. Once you configure remote Python interpreter in PyCharm, then it works out of the box. However, today after upgrading to PyCharm Professional 2018.2.1, I could not run my Python script on remote device. The execution always failed with below error - "Error running 'hello': Python helpers are not copied yet to the remote host. Please wait until remote interpreter initialization finishes." To solve this issue, I had to remove the ".pycharm_helpers " folder from the remove device and then restart PyCharm so that the folder is re-created and files are copied again. Here are the steps with comma...
12 comments
Read more

Customized Crosshair with OxyPlot charting library

I am using Oxyplot to draw heatmap for a WPF project and needed to draw a crosshair that moves according to user clicks. Since I couldn't find any good example or documentation on the topic, I made a small hack by using LineAnnotations and by over-riding Oxyplot mouse click event. Here is the sample code using WPF with MVVM pattern- MainWindow.xaml <Grid>         <oxy:Plot x:Name="CrossHairPlot">             <oxy:Plot.Axes>                 <oxy:LinearAxis Key="MyXAxis" Position="Bottom" IsZoomEnabled="False"/>                 <oxy:LinearAxis Key="MyYAxis" Position="Left" IsZoomEnabled="False"/>                 <oxy:LinearColorAxis Key="...
2 comments
Read more

Fixing git error: "remote: Repository not found"

I was trying to modify one of my private repository in GitHub and ran into the below error - git clone https://github.com/<user>/DocTest.git Cloning into 'DocTest'... remote: Repository not found. fatal: repository 'https://github.com/<user>/DocTest.git/' not found After lot of trial and error attempts, I figured out that my Windows 10 PC had stored github user credentials, so it didn't let me clone a private repository which was not accessible to the saved user. This is how we can clear any saved cache - Open Control Panel from the Start Menu Select User Accounts Select "Manage your credentials" in the left hand menu Delete all user credentials related to Git or GitHub After doing that, the error was gone and I was able to clone the repositories.
Post a Comment
Read more